Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

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 N3022SMcnulty Bobby J · Luling, LABuilt 1967 · S/N 15066922 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 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 N3026FMock1 LLC · Abingdon, VABuilt 1966 · S/N 18257126 N3026QSuper D Group LLC · Hanoverton, OHBuilt 1967 · S/N 18258026 N3026SSolewin Kimberly M · Christoval, TXBuilt 1967 · S/N 15066926 N3026YEpss LLC · Tavernier, FLBuilt 1962 · S/N 18254026 N30275Tomlinson Douglas F · Waunakee, WIBuilt 1968 · S/N 17701167 N3027FSale Reported · Watford City, NDSale reported, pending cancellationBuilt 1966 · S/N 18257127 N3027XSchneider Benjamin J · Wheeling, WVBuilt 1966 · S/N 15064427 N3028QAllenspach Timothy L · Stillwater, MNBuilt 1967 · S/N 18258028 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 N3029QOzarks Auto Show Inc · Hollister, MOBuilt 1967 · S/N 18258029 N3029SBlawusch Richard K · Waterloo, WIBuilt 1967 · S/N 15066929 N3029XRegistered aircraftS/N 15064429 N302DBHouston Chet H · Beaufort, SCBuilt 1968 · S/N 17701132 N302GPInternational Air Services Inc Trustee · Carson City, NVS/N 21058682 N302STManagement Support Services LLC · Naturita, COBuilt 1968 · S/N T210-0350 N302USolomon Mark Trustee · Wilmington, DEBuilt 1964 · S/N 18255529 N30302Kamenar Service LLC · Mukwonago, WIBuilt 1968 · S/N 17701180 N30303Registration Pending · Meeker, CORegistration pendingBuilt 1968 · S/N 17701181 N30304Williams Rod · Atascadero, CABuilt 1968 · S/N 17701182 N30307Johnston Phillip Jr · Pensacola, FLBuilt 1968 · S/N 17701184 N30308Griffith Scot E · Glendale, AZBuilt 1968 · S/N 17701185 N3030FThirty Thirty Club · Lebanon, ORBuilt 1966 · S/N 18257130 N3030YSamaniego Alejandro · Tucson, AZBuilt 1962 · S/N 18254030 N30311Parker Yates · Wellington, TXBuilt 1968 · S/N 17701188 N30316L & M Aviation LLC · Creston, IAS/N 17701189 N30317Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17701190 N3031FAlderson John M · Venice, CABuilt 1966 · S/N 18257131 N3031YAir Repair Inc · Cleveland, MSBuilt 1962 · S/N 18254031 N30328Martin Paul T · Tacoma, WABuilt 1968 · S/N 17701196

Back to AD 72-03-03 R3