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.

N6169TZelner Gregory · Merritt Island, FLBuilt 1964 · S/N 15060869 N616DHSenegal Steven L · San Bruno, CAS/N 01 N616JSwartzendruber Brett · Hesston, KSBuilt 1965 · S/N JC-502 N616NLogback Michael R · Mcpherson, KSBuilt 1972 · S/N 1 N616PTPrice Penelope · Bloomington, INBuilt 1946 · S/N 2705 N6170THerman David B · Seattle, WABuilt 1964 · S/N 15060870 N6171EAvequities Inc · Dallas, TXBuilt 1958 · S/N 46271 N6171GMission Flight Academy · Yucaipa, CAS/N 15071671 N6172EKatz Braunschweig Daniel A · Staten Island, NYBuilt 1958 · S/N 46272 N6172GTappan Scott M · Port Saint Lucie, FLBuilt 1969 · S/N 15071672 N6172HHathaway Michael W P · Fairbanks, AKBuilt 1946 · S/N 19345 N6172TMckinney Peggy A · Hamersville, OHBuilt 1964 · S/N 15060872 N6173TGreat Pilots LLC · Rocklin, CABuilt 1965 · S/N 15060873 N6174ECano Michael J · Vallecito, CABuilt 1958 · S/N 46274 N6174GMosley Gabriel T · Oak Hills, CABuilt 1969 · S/N 15071674 N6175ENeilson Craig H · Vista, CABuilt 1958 · S/N 46275 N6176EBullit Enterprises Ltd · Wshngtn Ct Hs, OHS/N 46276 N6176KDeal Clarence · Jonesboro, GABuilt 1975 · S/N 15077571 N6176TMatta Figueroa Eduardo · Chapman, KSBuilt 1964 · S/N 15060876 N6177EByrom Nathanto · Grass Valley, CAS/N 46277 N6177KMoses Annie R · Uvalde, TXBuilt 1975 · S/N 15077572 N6178EWaak Harlan L · Lincoln, NEBuilt 1958 · S/N 46278 N6178TRobinson Don · Peotone, ILS/N 15060878 N6179EHolland Frederic A · Advance, NCBuilt 1958 · S/N 46279 N6179TCullipher William L · Texarkana, TXBuilt 1964 · S/N 15060879 N6180EUtica Township Vol Firefighter Assn Inc · Jeffersonville, INBuilt 1958 · S/N 46280 N6180KHutton Stephen · Madison, MSBuilt 1975 · S/N 15077573 N6181HFisher Darryl Eugene Trustee · Carson City, NVBuilt 1946 · S/N 19353 N6182TLuxaire Center Inc · Deland, FLS/N 15060882 N6184ERosborough Todd D · Medford, ORBuilt 1958 · S/N 46284 N6184TBormann Wayne T · Valley Center, KSBuilt 1964 · S/N 15060884 N6185GJuel Thomas Gavin · Everett, WAS/N 15071685 N6185KLa Porta John R · Des Moines, WABuilt 1975 · S/N 15077576 N6185TRobinson David B · Fair Oaks, CABuilt 1964 · S/N 15060885 N6186EHadley Ralph James Jr · Saint Clairsville, OHBuilt 1958 · S/N 46286 N6186KSopalsky John J · Goshen, NYBuilt 1975 · S/N 15077577 N6187EBasham James L · Livingston, TXS/N 46287 N6187GMiller George Chris · Lone Oak, TXBuilt 1969 · S/N 15071687 N6187TGulfstream Design Associates Inc · Delray Beach, FLBuilt 1964 · S/N 15060887 N6188ECs Aircraft Services LLC · Jefferson, ORS/N 46288 N6188FSky High Adventures LLC · Wilmington, DES/N A1500441 N6188KLanning 2 Aviation LLC · Amarillo, TXBuilt 1975 · S/N 15077578 N6189ETrato Sharon M · Millington, MIFirst renewal noticeBuilt 1958 · S/N 46289 N6189GBrule Alan R · Crookston, MNBuilt 1969 · S/N 15071689 N6189TBlack Archie C · Colton, CABuilt 1964 · S/N 15060889 N618SBTucker William F · Booneville, ARBuilt 2015 · S/N 001 N618TETuskegee Eagles Of St Joseph Mo · Agency, MOBuilt 2021 · S/N 4846 N61903Piper Cub N 61903 Inc Trustee · Wilmington, DEBuilt 1942 · S/N 8263 N6192ECook Christopher M · Burnet, TXS/N 46292 N6192TAustin James M · Fort Worth, TXS/N 15060892

Back to AD 94-05-05 R1