Skip to content

Registered aircraft · 20,481

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N71748Altom Marvin L · Reno, NVS/N 18259737 N7174ESuazo Tito L · Glendale, AZBuilt 1959 · S/N 52174 N71752Wings Over Ouray LLC · Ouray, COBuilt 1969 · S/N 18259738 N71753Gibbs Aubrey Damon · Cumming, GABuilt 1969 · S/N 18259739 N7175QTcb Solutions LLC · Milledgeville, GABuilt 1973 · S/N 18262042 N71766Habermann William J · Hardwick, NJBuilt 1969 · S/N 18259746 N71769Hartung Daniel H · Moiese, MTBuilt 1969 · S/N 18259747 N7176EBuggy Bath Unlimited LLC · Sheridan, WYBuilt 1959 · S/N 52176 N71770Terrill Terrence O · Pueblo West, COBuilt 1969 · S/N 18259748 N71772Glh Enterprises LLC · New Boston, NHBuilt 1969 · S/N 18259749 N71773Darrach Todd I · Rhome, TXS/N 18259750 N71774Reif Welding And Construction LLC · Plainville, KSBuilt 1969 · S/N 18259751 N71785Skylane Inc · Woodstock, GABuilt 1969 · S/N 18259756 N71788Gospel Flight Aviation LLC · Kissimmee, FLS/N 18259758 N7179EHoem Shawn M · Emmett, IDBuilt 1959 · S/N 52179 N717CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282250 N717DKRegistration Pending · North Las Vegas, NVRegistration pendingBuilt 1973 · S/N 21060113 N717SWHannibal Lee W · Rathdrum, IDBuilt 1977 · S/N 18052861 N717TYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1985 · S/N 21064946 N71805British Automotive Ltd DBA · Seattle, WABuilt 1969 · S/N 18259763 N71809Putnam Larry D · Livermore, CABuilt 1969 · S/N 18259764 N7180EPrice William T III · Chuckey, TNBuilt 1959 · S/N 52180 N71811Weed Eater LLC · Canton, OHBuilt 1969 · S/N 18259765 N71812Flight Patterns LLC · Okanogan, WABuilt 1969 · S/N 18259766 N71815Whipple Daniel C · Coon Rapids, MNBuilt 1969 · S/N 18259767 N71818Price Norman S · Prineville, ORFirst renewal noticeBuilt 1969 · S/N 18259769 N71821Hayes Harlan L · Salem, ORS/N 18259770 N7182EShoreline Consulting Inc · Bryan, TXBuilt 1959 · S/N 52182 N7182QMullins Albert A · Boling, TXS/N 18267345 N71831Kellogg Morgan · Missoula, MTBuilt 1969 · S/N 18259771 N71833Vega Al · Windsor, CAS/N 18259772 N71844Rusinsky Michael John · Amagansett, NYBuilt 1969 · S/N 18259775 N71846C3 Aviation LLC · Eustis, FLBuilt 1969 · S/N 18259776 N7184QHolubar Properties Inc · Mckinney, TXBuilt 1973 · S/N 18262045 N7185ENenadic John P · Camas, WABuilt 1959 · S/N 52185 N71860Young Reginald L · Fort Worth, TXBuilt 1969 · S/N 18259783 N71866Lkn Skylane LLC · Mooresville, NCBuilt 1969 · S/N 18259785 N71867Friend Troy L · Wyandotte, OKBuilt 1969 · S/N 18259786 N71876Rasmussen Paul · Long Lake, NYBuilt 1969 · S/N 18259788 N71879Sale Reported · Greeley, COSale reported, pending cancellationBuilt 1969 · S/N 18259789 N7187RFlying Roaches LLC · Dallas, TXBuilt 1999 · S/N 18280557 N71880Meeks Michael D · Marion, TXBuilt 1969 · S/N 18259790 N71884Smith John L Trustee · Zephyr Cove, NVBuilt 1969 · S/N 18259792 N7188EWashick Timothy J · South Lake Tahoe, CABuilt 1959 · S/N 52188 N71890Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 18259794 N71896Silver Eagles Flying Club Inc · Armonk, NYBuilt 1969 · S/N 18259795 N718APAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1977 · S/N 21061857 N718CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281713 N718JSBrewster Scott · Sedona, AZS/N 18265417 N718MJValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N R18200461

Back to AD 84-10-01 R1