Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N6609APelon Robert C · Chugiak, AKBuilt 1956 · S/N 28709 N6609FMcalexander William Dean · Conover, OHBuilt 1966 · S/N 15063209 N660TXMeinen Jay · Kingwood, TXBuilt 2008 · S/N 650-108 N66105Everett Stanley J · Cumming, GABuilt 1974 · S/N 15075838 N6610AAccurso Jacob · Siletz, ORBuilt 1956 · S/N 28710 N6610FCabala Nicholas C · Bay City, MIBuilt 1966 · S/N 15063210 N6610GThomas Charles L · Yankton, SDBuilt 1970 · S/N 15072110 N66110Krikorian Philip · Fresno, CABuilt 1974 · S/N 15075843 N66115Hayes Orris E · Betsy Layne, KYBuilt 1974 · S/N 15075846 N66118Segarra Jo Ann · Ponce, PRFirst renewal noticeBuilt 1974 · S/N 15075849 N66119Northwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 15075850 N6611FMehsling Thomas C · Byers, COBuilt 1966 · S/N 15063211 N66120Osten Albert M · Poughkeepsie, NYBuilt 1974 · S/N 15075851 N66127Gulley Cameron L · Eastland, TXBuilt 1974 · S/N 15075856 N6612AMazac Kennith M · River Falls, WIBuilt 1956 · S/N 28712 N6612FG & M Holdings LLC · Cedar Rapids, IABuilt 1966 · S/N 15063212 N6612NHauer James D · Winthrop, MNBuilt 1949 · S/N 13012 N66134Jacobs Inc · Huntsville, ALBuilt 1974 · S/N 15075862 N66137Calvert John · Tybee Island, GABuilt 1975 · S/N 15075864 N66140Whitehead Patrick D · Cross Junction, VABuilt 1974 · S/N 15075866 N66147Leckman Richard · Sequim, WABuilt 1974 · S/N 15075870 N66148Hooie Jon Paul D · N Fort Myers, FLBuilt 1974 · S/N 15075871 N6614AHanks Mitchell L · Carthage, ILS/N 28714 N6614GDonaldson Charles R · Marfa, TXS/N 15072114 N6614NWilliams Russell Dale · Rehoboth Beach, DEBuilt 1949 · S/N 4-13014 N66152Aeromarine Airways Inc · Miami, FLBuilt 1974 · S/N 15075875 N66154Registration Pending · Bandon, ORRegistration pendingBuilt 1974 · S/N 15075877 N66157Respess Malvin R · Pantego, NCBuilt 1974 · S/N 15075880 N66158Sublett Timothy M · Raleigh, NCBuilt 1974 · S/N 15075881 N66159Ard Terry D · Mount Vernon, IABuilt 1974 · S/N 15075882 N6615EBranstner August M · Taft, CABuilt 1959 · S/N 56115 N6615SStott Thomas W · Fort Shaw, MTBuilt 1967 · S/N 15067415 N66164Best Myra J · Sullivan, OHBuilt 1974 · S/N 15075886 N6616EBurger Rodney K · Monroe, UTBuilt 1959 · S/N 56116 N6616GSale Reported · Pineville, LASale reported, pending cancellationS/N 15072116 N6616TTechnical Education Services Inc · Virginia Beach, VABuilt 1960 · S/N 59016 N66173Crawford Derrell D · Hot Springs, ARBuilt 1974 · S/N 15075894 N66178Allison Christopher D · Pensacola, FLBuilt 1974 · S/N 15075898 N6617GGeneral Aviation Holdings LLC · Port Orange, FLBuilt 1970 · S/N 15072117 N6617SKembel Robert D · Saint Ignatius, MTS/N 15067417 N6617TMacario T Michael III · Townsend, DEFirst renewal noticeBuilt 1960 · S/N 59017 N66181Adr Aircraft Service Inc · Burbank, CABuilt 1974 · S/N 15075900 N66188Mcghie John · Concord, NHBuilt 1974 · S/N 15075906 N6618EWilson Eliott R · Gallipolis, OHBuilt 1959 · S/N 56118 N6618GKonkle Tyrel J · Morristown, TNBuilt 1970 · S/N 15072118 N6618HSmithson Charles W · Wasilla, AKBuilt 1946 · S/N 19810 N6618SLipski Robert · Wallingford, CTBuilt 1967 · S/N 15067418 N66192Roberts John G · Brandon, MSBuilt 1974 · S/N 15075909 N66194Holmes Community College · Goodman, MSBuilt 1974 · S/N 15075910 N66195Sockey Investments LLC · Poteau, OKBuilt 1974 · S/N 15075911

Back to AD 94-05-05 R1