Skip to content

Registered aircraft · 20,683

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.

N6490BPontoni Peter D · Athens, MIBuilt 1957 · S/N 29690 N6490DCampbell James W · Joshua, TXBuilt 1979 · S/N 17272832 N64915Northwoods Air LLC · Orono, MEBuilt 1982 · S/N 17275649 N64918Loeser Harold · Boca Raton, FLBuilt 1982 · S/N 17275651 N64919Hawk III Flyers Club · Republic, PABuilt 1973 · S/N 17262850 N6491EToepfer Kendra · BielefeldBuilt 1959 · S/N 46591 N6492ELeadmon Lorren Dale Jr · Mechanicsville, MDBuilt 1978 · S/N 17272024 N6493BBoyd Ryan D · Stockton, CABuilt 1956 · S/N 29693 N64943Tipton Donald Jeffrey Sr · Maryville, TNBuilt 1982 · S/N 17275657 N6495BSanford George W Jr · Montross, VABuilt 1957 · S/N 29695 N64962Wingsleasing LLC · Wichita, KSBuilt 1982 · S/N 17275659 N64964Dodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275660 N64966Hill Mark T · Gloucester, VABuilt 1982 · S/N 17275661 N6496BStartup Aviation Management LLC · Lakeway, TXBuilt 1957 · S/N 29696 N64972Fixed Wing Holding Company Inc · Pembroke Pines, FLS/N 17275662 N6497BVeve Rafael A · Indn Hbr Bch, FLBuilt 1957 · S/N 29697 N6498BDunlap Paul C Jr · Rock Island, TNBuilt 1956 · S/N 29698 N6498ECallender Roy A Jr · Ennis, TXBuilt 1959 · S/N 46598 N6498FWisener Randall G · Addison, ALBuilt 1979 · S/N 17273232 N6499BMoore Thomas W · Zimmerman, MNFirst renewal noticeBuilt 1957 · S/N 29699 N6499EAzevedo Manuel J · Modesto, CABuilt 1959 · S/N 46599 N649ESFlymore Aviation LLC · Philadelphia, PABuilt 1975 · S/N 172-64536 N649GCAviation Paradise LLC · Homestead, FLBuilt 1979 · S/N 17273413 N649TCSpartan Education Group LLC · Tulsa, OKBuilt 2000 · S/N 172S8649 N64AFVermont Flight Academy · South Burlington, VTBuilt 1997 · S/N 17280069 N64CASwaz Aviation LLC · Mesa, AZBuilt 1981 · S/N 17275269 N64EFHampton Flying Services LLC · Portsmouth, NHBuilt 1973 · S/N 17262871 N64JAJet Air Inc · Iowa City, IABuilt 2001 · S/N 17281065 N64PDPapa Delta LLC · Eddyville, KYBuilt 1979 · S/N 17272996 N64PWM&G Aircraft Management LLC · Aurora, ORBuilt 2024 · S/N 172S13212 N64SFSafe Flight Instrument Corp · White Plains, NYBuilt 1977 · S/N 17268706 N64SSGriffiths Jon · Carson City, NVBuilt 1975 · S/N 17265345 N64TSLippincott George T · Thermopolis, WYBuilt 1981 · S/N 172RG0959 N64WGM&G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12753 N65001Dornak Henry E Jr · Corpus Christi, TXBuilt 1982 · S/N 17275665 N65003Major Air LLC · Charleston, SCBuilt 1982 · S/N 17275666 N65021Borda Anthony J · West Chester, PABuilt 1982 · S/N 17275670 N65032Vavrek Holly Kay · Palm City, FLBuilt 1982 · S/N 17275672 N6503DManubay John M · Sinking Spring, PABuilt 1979 · S/N 17272834 N6503VSt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 172RG0736 N65040Mc Creery Aviation Co Inc · Mcallen, TXS/N 17275673 N65045Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1982 · S/N 17275674 N6504VYoung Charles Wade · Rogers, ARBuilt 1980 · S/N 172RG0737 N65057Good Winds LLC · Waterville, MEBuilt 1982 · S/N 17275677 N65058Organization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1982 · S/N 17275678 N65065Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275681 N6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTBuilt 1979 · S/N 17272835 N6508HBkb Inc · Newport, MIBuilt 1975 · S/N 17265469 N6508KTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274205 N6509HSale Reported · Benton, KSSale reportedBuilt 1975 · S/N 17265470

Back to AD 90-06-03 R1