Skip to content

Registered aircraft · 25,369

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.

N677KSassinsky Jeffrey B · Haddonfield, NJBuilt 1965 · S/N 3178 N677PCTraven Ricardo Siro · Matthews, NCS/N P21000677 N67807Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15282031 N6780HMerrell Shane F · Shelby, ALBuilt 1975 · S/N 17265579 N6780NMegee Michael J · Fort Mohave, AZS/N 680088 N6780VLimpert Theodore H · Syracuse, NYBuilt 1970 · S/N 700061 N67810Hernandez Jason Joseph · Allen, TXBuilt 1978 · S/N 15282033 N67818Tlb Inc · Howell, NJBuilt 1978 · S/N 15282036 N6781NThornton Brad · Decatur, TXBuilt 1968 · S/N 680089 N6781VSullivan Michael G · Newport Beach, CABuilt 1970 · S/N 700063 N67825Kentucky Airmotive Inc · Mt Sterling, KYBuilt 1978 · S/N 15282040 N6782HJb Aviation Management Inc · Wonder Lake, ILBuilt 1975 · S/N 17265580 N6782NSudeten Inc · Wilmington, DEBuilt 1968 · S/N 680094 N6782VRose Gary E · Mendocino, CABuilt 1970 · S/N 700082 N6783NBaker Dennis M · Temple Terrace, FLBuilt 1968 · S/N 680090 N67840Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282049 N67842Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1978 · S/N 15282051 N67844Patel Pragnesh · Cerritos, CABuilt 1978 · S/N 15282053 N67847Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15282056 N6784NGrundmann William B · Bradenton, FLBuilt 1968 · S/N 680091 N6784UMellen Roger B · Winston, ORBuilt 1963 · S/N 2506 N6784VN6784v LLC · Casper, WYBuilt 1970 · S/N 700083 N67852Sunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15285312 N67856Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282061 N67859Guerra Gerald T · Sandusky, OHBuilt 1978 · S/N 15282063 N67864Amoth Travis M · Princeton, CABuilt 1978 · S/N 15282068 N67865Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1978 · S/N 15282069 N6787HGordon Caleb J · Waukesha, WIBuilt 1975 · S/N 17265582 N6787NN6787n LLC · Hanover, NHBuilt 1968 · S/N 680093 N67888Flight Directors LLC · Fifield, WIBuilt 1978 · S/N 15282077 N6788NSamples Kurtis K · Dallas, TXBuilt 1968 · S/N 690001 N6789NOwnbey James L · Lubbock, TXBuilt 1968 · S/N 680094 N678ACHabetz Kenneth B · Ragley, LABuilt 1998 · S/N 403-98 N678CTSanborn Thomas W · College Station, TXBuilt 1978 · S/N P21000019 N678GHHamilton Gilbert R · Leesburg, VABuilt 1977 · S/N 177RG1283 N678KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15281673 N67904Mirza Wajahat · College Station, TXBuilt 1978 · S/N 15282089 N6791NHowarth Craig A · Stansbury Park, UTBuilt 1968 · S/N 680097 N67920Thompson William G · Mattawa, WABuilt 1978 · S/N 15282099 N67923Kaluahine Fredstan K · Lihue, HIS/N 15282101 N67924N67924 LLC · Somers, CTBuilt 1978 · S/N 15282102 N6792NWhite Rock Advisors · Wenham, MABuilt 1968 · S/N 680096 N6792VSchmidt Jason A · Wasilla, AKBuilt 1970 · S/N 700085 N67930Colonial Air Inc · New Bedford, MABuilt 1978 · S/N 15282106 N6794EWalls Jerry L · Hawley, TXS/N 17272067 N6794HPs N6794h LLC · Green Bay, WIBuilt 1975 · S/N 17265583 N6794NHatcher David J · Papillion, NES/N 680098 N6794VNewman James · Gillette, WYBuilt 1970 · S/N 700068 N67958Stone Wall Acres · Antigo, WIBuilt 1978 · S/N 15282115 N6795NStief Todd F · Mount Pleasant, SCBuilt 1968 · S/N 680098

Back to AD 80-25-07 R1