Skip to content

Registered aircraft · 26,230

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.

N11913Sharkey Peter T · Providence, RIBuilt 1974 · S/N 15075706 N1191FStopa Gary · Florida, NYBuilt 1966 · S/N 17254786 N11927Omlid Robert · Watford City, NDBuilt 1974 · S/N 15075712 N1192HEberhardt William G · Orland, MEBuilt 1948 · S/N 15AC-204 N11935Legacy Pilot Training LLC · Annandale, MNBuilt 1974 · S/N 15075713 N11936West Yayoi M · Sonoma, CABuilt 1974 · S/N 15075714 N11938Johnson William L · Middleburg, VAFirst renewal noticeBuilt 1974 · S/N 15075716 N11940Elkeberry Morgan T · Sycamore, OHBuilt 1974 · S/N 15075718 N11942Puls Kurt V · Valparaiso, INS/N 15075720 N11944Weed Ellen M · Gassaway, WVBuilt 1974 · S/N 15075722 N11946Solari Michael R · Gilroy, CABuilt 1974 · S/N 15075724 N11952Jones William Edward · Scottsdale, AZBuilt 1974 · S/N 15075730 N11953Sanchez Chayanne R · Apex, NCBuilt 1974 · S/N 15075731 N11957Kopecky Dawn D · Center, NDBuilt 1974 · S/N 15075735 N11959Quyser Adil · Edison, NJBuilt 1974 · S/N 15075737 N11962Aeroleasing Inc · Medford, ORBuilt 1974 · S/N 15075740 N1196YYork Aero Club Inc · York, SCBuilt 1962 · S/N 15059596 N11970Kiforishin Samuel · Westfield, MAS/N 15075748 N11971Registration Pending · Durham, NCRegistration pendingBuilt 1974 · S/N 15075749 N11974Yilmaz Enes A · Austin, TXBuilt 1974 · S/N 15075752 N1197BDeyoe Thomas B · Beaver, ORBuilt 1947 · S/N 5824 N1198FStockle Barry W · Oakland, CABuilt 1966 · S/N 17254793 N1199BBowen Allan R · Brockport, NYS/N 5826 N119DHJohnson Peter L · Chico, CAS/N 36257 N119TXJulicher Mark R · Bulverde, TXBuilt 1947 · S/N 7BCM-343 N11AJTailwinds Services And Commodities Inc · Brandon, MSS/N 5102 N11EZNipp Michael P · Nampa, IDS/N 04 N11FNScheck Christopher R · Troutdale, ORBuilt 1973 · S/N 15074423 N11GDPiccolo Marc · Alexandria, VABuilt 1945 · S/N 14847 N11GSHuddleston Edward · Oaktown, INBuilt 1976 · S/N 15078597 N11HFBell Michael S · Trinity, TXBuilt 1946 · S/N 1191 N11HGShooting Star Services LLC · Rosamond, CABuilt 2003 · S/N 015 N11JTJjj Ventures LLC · Bronx, NYBuilt 1969 · S/N 15071181 N11KTHilborn Rebecca M · Addison, NYBuilt 1956 · S/N 28593 N11LHMurphy J Patrick L · Oconomowoc, WIS/N 111 N11MRezich James N · Winnebago, ILS/N RB1S N11MGMerhar Richard D · Rocky River, OHBuilt 1963 · S/N FJS-2 N11MKMckenney Robert N · Schertz, TXBuilt 1946 · S/N 15748 N11MSLiefeld Scott A · Lancaster, CABuilt 1972 · S/N MS1 N11SDavis Susan J · Castroville, CABuilt 1947 · S/N 11-273 N11VBuckner Eldon L · Baker City, ORBuilt 1959 · S/N 55819 N11WDRegistration Pending · Rochester, WARegistration pendingBuilt 1973 · S/N 12-19-19 N11XPFolkins Cleon P · Spokane, WABuilt 1980 · S/N 1 N11YWBaldwin William E · Kula, HIBuilt 1970 · S/N 15072351 N12008Dvoracek Dana J · Charlevoix, MIBuilt 1963 · S/N 18 N12009Jordan Ronald W · Stoutsville, OHS/N 19 N1200GHartmann Kaiser Robert · New York, NYBuilt 1972 · S/N 15073901 N1200L1st American Aviation Inc · North Miami, FLBuilt 1959 · S/N 17785 N1200YMillner Jack A · Toledo, OHBuilt 1962 · S/N 15059600 N12011Marsh John Edward · Washington, DCS/N 21

Back to AD 94-05-05 R1