Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N92004Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281621 N92006Troughton Jill A · Spring Hill, FLBuilt 1973 · S/N 17261535 N9200BChristiansen Aviation LLC · Wilmington, DEBuilt 2012 · S/N 17281620 N92014Shotwell Land Management Co LLC · Jackson, MSS/N 17261538 N9201HSparkwizard LLC · Greenville, RIBuilt 1975 · S/N 17266012 N92026Haltom Frances F · Alva, OKS/N 17261539 N9202UOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281622 N92035Ford Daniel T · Warsaw, INBuilt 1973 · S/N 17261540 N920AJAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263234 N920CFWingsleasing LLC · Wichita, KSBuilt 1997 · S/N 17280112 N920CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8341 N920EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12512 N920GBales Don · Oakhurst, CABuilt 1981 · S/N 172RG0901 N920MTAcron Aviation Academy Inc · Sanford, FLBuilt 2006 · S/N 172S10214 N920TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 2004 · S/N 17281206 N920WBJet Air Inc · Iowa City, IABuilt 2008 · S/N 172S10837 N92103Pgd Flyers Inc · Cape Coral, FLBuilt 1973 · S/N 17261545 N9210HFlex Air Holdings Inc · Wilmington, DEBuilt 1975 · S/N 17266017 N92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYBuilt 1973 · S/N 17261546 N92141High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17261549 N92159Buster Aviation LLC · Harveys Lake, PABuilt 1973 · S/N 17261550 N92161Skywarrior Flight Training Inc · Pensacola, FLBuilt 1973 · S/N 17261551 N92169Welch William Ben · Danville, ILBuilt 1973 · S/N 17261553 N9216HBurgess Alan P · Corona, CABuilt 1975 · S/N 17266020 N9219HKful Flyers Foundation Inc · Fullerton, CABuilt 1975 · S/N 17266021 N921AARegistration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 17261752 N921BBNorthwestern Michigan College · Traverse City, MIBuilt 2024 · S/N 172S13232 N921EZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 172S8499 N921TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280244 N92228Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11498 N9222HDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11497 N9223CDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11499 N9223EDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11500 N9223HHallock Robert C III · Sag Harbor, NYBuilt 1975 · S/N 17266024 N9223XDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11501 N92255Kloker Daniel E · Owasso, OKBuilt 1973 · S/N 17261554 N92264Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11502 N92266Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11503 N9226HDebt LLC · Yuma, AZBuilt 1975 · S/N 17266026 N9229FCooke John W III · Carthage, TXBuilt 1997 · S/N 17280294 N922CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8911 N922EAButler Ronald A · Cumming, GAS/N 17263921 N922LHClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13554 N922TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280249 N92306High Wingers Inc · Racine, WIBuilt 1973 · S/N 17261557 N92307Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261558 N9230YDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11505 N92318Flitepro Inc · Murrieta, CAS/N 17261561 N92324Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 17261562 N92356Hub City Aviation Academy LLC · Lubbock, TXBuilt 1973 · S/N 17261567

Back to AD 90-06-03 R1