Skip to content

Registered aircraft · 25,368

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N93689Board Of Trustees DBA · Murphysboro, ILBuilt 1982 · S/N 15285535 N9368VMontrose Paul F · Greenbrier, ARBuilt 1969 · S/N 700013 N9369RTwark Eric James · Fort Collins, COBuilt 1978 · S/N R18200699 N9369TTarno Suzzan G · Avondale, AZBuilt 1978 · S/N 38-78A0074 N9369YBk Aviation Services LLC · Yorba Linda, CABuilt 1981 · S/N 21064488 N936AZN936az LLC · Miami, FLBuilt 1979 · S/N 17272075 N936MBBergstrom Aircraft Inc · Pasco, WABuilt 1978 · S/N 17270211 N93706Drake Charles R · Claremore, OKBuilt 1982 · S/N 15285539 N9371VFly Me To The Mooney LLC · Owings Mills, MDBuilt 1969 · S/N 700019 N9372HN9372h LLC · Wilmington, DEBuilt 1975 · S/N 17266123 N9372VFendley Bobby G · Fair Play, SCS/N 700013 N93730Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1982 · S/N 15285543 N9373MKelly Andrew J · Shirley, ARBuilt 1966 · S/N 1305 N9373VEl-Cheikh Taimour · Waldorf, MDBuilt 1969 · S/N 700020 N9374MRoberts Terry L · Bolt, WVBuilt 1966 · S/N 1306 N9375MSweeney David J · Portland, ORBuilt 1966 · S/N 1307 N9375VDavis Wesley · Dayton, OHBuilt 1969 · S/N 700021 N9376MBeans James B IV · Camas Valley, ORBuilt 1972 · S/N 17260576 N9376TMosley Kenneth N · Westlake Village, CABuilt 1978 · S/N 38-78A0079 N9377HAir Advantage Inc · Mount Pleasant, IABuilt 1975 · S/N 17266126 N9377MFlying Cookies LLC · Lyman, SCBuilt 1966 · S/N 670001 N9378DAndden Aviation LLC · Santa Monica, CABuilt 1983 · S/N 172RG1143 N9378MStratus Investment Corp · Lino Lakes, MNBuilt 1966 · S/N 670002 N9378VN83993 LLC · Cherry Hill, NJBuilt 1969 · S/N 700016 N9379HCitizen Air LLC · Port Angeles, WABuilt 1975 · S/N 17266128 N9379YFitzgerald Aviation LLC · Bluffton, SCBuilt 1981 · S/N 21064491 N937ASGc Aviation Services-1 LLC · Miamisburg, OHS/N 172RG1178 N937BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1987 · S/N 24-3046 N9380MSmith Ralph · Bel Air, MDBuilt 1966 · S/N 670004 N9380RFarm Air Inc · Astoria, ILBuilt 1975 · S/N 18802268 N9382DN9382d LLC · Wake Forest, NCBuilt 1983 · S/N 172RG1145 N9382MBonifay Jason · Corona Del Mar, CABuilt 1966 · S/N 670006 N9382VWesterhold Wayne E · Cary, NCBuilt 1969 · S/N 700024 N93831Christiansen Aviation LLC · Wilmington, DEBuilt 1982 · S/N 15285557 N9383MTitle Benjamin H · Arlington, VABuilt 1966 · S/N 670007 N9384MNorfolk Aviation LLC · Norfolk, VAS/N 670008 N9385GDakota Aircare Inc · Wagner, SDBuilt 1974 · S/N 18801468T N9385LFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1986 · S/N 17276548 N9386MWhite Jason · Lewes, DEBuilt 1966 · S/N 670010 N9386REnsing Maris J · Orange, CABuilt 1978 · S/N R18200701 N9386VSwaney Matthew P · Thomasville, NCBuilt 1969 · S/N 700026 N9387DPrecise Flight LLC · Waukesha, WIBuilt 1984 · S/N 172RG1148 N9387HAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1975 · S/N 17266131 N9387MKastner Doug · Prineville, ORBuilt 1966 · S/N 670011 N9387TAnczarski John J · Ringtown, PABuilt 1978 · S/N 38-78A0086 N9387VPabst Erik R · Claremont, CABuilt 1969 · S/N 700018 N9388MN9388m LLC · Sheridan, WYBuilt 1966 · S/N 670012 N9389ELandr One LLC · Bozeman, MTBuilt 1979 · S/N 17272242 N9389LL A M Capital Management LLC · Sheridan, WYBuilt 1986 · S/N 17276549 N9389MRutledge Richard L · Hurst, TXBuilt 1966 · S/N 670013

Back to AD 80-25-07 R1