Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N3021JDuffy William B · Denton, TXBuilt 1965 · S/N 15061121 N3021QPicco Anthony · Sykesville, MDBuilt 1967 · S/N 18258021 N3021SCollett Danny W · Stewart, TNBuilt 1967 · S/N 15066921 N3021XMay'S Welding Service Inc · Cotulla, TXS/N 15064421 N3021YBrancao Bryan A · Norco, CABuilt 1962 · S/N 18254021 N30225Hall Curtis B · Shepherdsville, KYBuilt 1968 · S/N 17701131 N3022AReese Brandon A · Bend, ORBuilt 1953 · S/N 25666 N3022EBoulais Aaron · Upland, CABuilt 1982 · S/N 18268227 N3022SMcnulty Bobby J · Luling, LABuilt 1967 · S/N 15066922 N3022VRetroair Restoration LLC · Big Lake, AKBuilt 1974 · S/N 15076354 N3022XCintim LLC · Carrabelle, FLS/N 15064422 N30231Pankratz Paul J · Lakeville, MNBuilt 1968 · S/N 17701136 N30235Booher Harold D · Manchester, MOBuilt 1968 · S/N 17701139 N30238Nunley Dwight · Hawkins, TXBuilt 1968 · S/N 17701142 N30239Jones Gary E · Orange, CABuilt 1968 · S/N 17701143 N3023APhillips Danny W · Jefferson, TXBuilt 1953 · S/N 25667 N3023FJones Clinton D · Santa Rosa Beach, FLBuilt 1966 · S/N 18257123 N3023SSynnes Dale C · Santa Paula, CABuilt 1967 · S/N 15066923 N3023YMorgan Lee Blanchard · Albuquerque, NMFirst renewal noticeS/N 18254023 N3024FSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18257124 N3024XDavis James M · Tuscaloosa, ALBuilt 1966 · S/N 15064424 N3024YTemple Curtis Lee · Porcupine, SDBuilt 1962 · S/N 18254024 N30250O'Connor Sean J · Newburyport, MABuilt 1968 · S/N 17701150 N3025FWarner Daniel M · Fremont, OHBuilt 1966 · S/N 18257125 N3025SHummer Bryant C · Garden Plain, KSBuilt 1967 · S/N 15066925 N3025UEddy Bruce A · Winfield, ALBuilt 1963 · S/N 17250625 N30268Rudd Terry R · Clarkston, WABuilt 1973 · S/N 21059903 N3026APowell Alvin L · Caldwell, IDS/N 25670 N3026FMock1 LLC · Abingdon, VABuilt 1966 · S/N 18257126 N3026JRoberts James D Trustee · Omaha, NEBuilt 1965 · S/N 15061126 N3026QSuper D Group LLC · Hanoverton, OHBuilt 1967 · S/N 18258026 N3026SSolewin Kimberly M · Christoval, TXBuilt 1967 · S/N 15066926 N3026VNew Mexico Flying Eagle Inc DBA · Tucson, AZS/N 15076355 N3026YEpss LLC · Tavernier, FLBuilt 1962 · S/N 18254026 N30275Tomlinson Douglas F · Waunakee, WIBuilt 1968 · S/N 17701167 N30278Barron Joseph M · Des Moines, IABuilt 1975 · S/N 17264133 N3027FSale Reported · Watford City, NDSale reported, pending cancellationBuilt 1966 · S/N 18257127 N3027XSchneider Benjamin J · Wheeling, WVBuilt 1966 · S/N 15064427 N30280Emery Clint L · Texarkana, ARBuilt 1973 · S/N 21059907 N30285Galena City School District · Galena, AKBuilt 1974 · S/N 17264135 N3028QAllenspach Timothy L · Stillwater, MNBuilt 1967 · S/N 18258028 N3028VChildress Sam · Weatherford, TXBuilt 1974 · S/N 15076357 N3028XFicken Jerome L · Cedar Hill, MOBuilt 1966 · S/N 15064428 N3028YStanton Tod J · Naperville, ILBuilt 1962 · S/N 18254028 N30293Advantage Aviation Services LLC · South Saint Paul, MNBuilt 1968 · S/N 17701177 N30297Siers Richard · Ocean Shores, WABuilt 1968 · S/N 17701178 N3029JSorrells Brandon L · Yuma, AZBuilt 1965 · S/N 15061129 N3029QOzarks Auto Show Inc · Hollister, MOBuilt 1967 · S/N 18258029 N3029SBlawusch Richard K · Waterloo, WIBuilt 1967 · S/N 15066929 N3029VFlyt LLC · Madison, MSS/N 15076358

Back to AD 79-10-14 R1