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.

N7145TZacharias Norman R · Hinckley, MNFirst renewal noticeBuilt 1959 · S/N 46745 N7145XAthol Orange Aero Club Inc · Athol, MABuilt 1961 · S/N 15059245 N71460Bright Sky LLC · Orwigsburg, PABuilt 2005 · S/N DH 38 N7146FR And R Plane LLC · Lewiston, IDBuilt 1966 · S/N 15063746 N7146MWright Roy E · Tulelake, CABuilt 1958 · S/N 55446 N71472Bedford Dennis L · Auke Bay, AKBuilt 1946 · S/N 2899 N71479Sale Reported · Elizabeth, COSale reportedBuilt 1946 · S/N 2906 N7147AAir Cover Academy LLC · Frankford, MOBuilt 1956 · S/N 29247 N7147FHernandez Jorge L · Luthersville, GABuilt 1966 · S/N 15063747 N7147GAffordable Flying LLC · Cedar Park, TXBuilt 1969 · S/N 17258847 N7147TMoody George A II · Dyersburg, TNBuilt 1959 · S/N 46747 N7147XBrooks Blaze W · Fairbanks, AKBuilt 1961 · S/N 15059247 N7148FHigh Flight Aviation Of Kentucky Inc · Lexington, KYFirst renewal noticeBuilt 1966 · S/N 15063748 N7148SJupiter Flight Service And Investing LLC · Lithonia, GAS/N 15067848 N7148XLong Thomas S · Longview, TXBuilt 1961 · S/N 15059248 N7149ASteffanic Matthew R · Bastrop, TXS/N 29249 N7149MBarton Danny B Trustee · White City, ORBuilt 1958 · S/N 55449 N7149SMcateer Kristy · East Greenwich, RIS/N 15067849 N7149TRb Associates · North Bend, ORBuilt 1959 · S/N 46749 N714ABHawke Ag Aviation Inc · Oakdale, CABuilt 1976 · S/N 15079017 N714ADRedding Courtland J · Gowen, MIBuilt 1976 · S/N 15079019 N714AEWackman Howard P · Elk Grove, CABuilt 1976 · S/N 15077874 N714AFStoberski John J · Henderson, NVBuilt 1976 · S/N 15079021 N714AGGreenwing Aviation & Welding Co · Lacon, ILBuilt 1976 · S/N 15079022 N714AJMarra Michael A · Carlisle, PABuilt 1976 · S/N 15079024 N714AMRadovanovic Dimitri · Newport Beach, CABuilt 1976 · S/N 15079027 N714APGhiselli William A III Trustee · Woodruff, WIBuilt 1976 · S/N 15079029 N714AQSale Kelly L · Priest River, IDS/N 15079030 N714AZMarsh Gary W · Hopkinsville, KYBuilt 1976 · S/N 15079039 N714BBHunter Jack D · Prattville, ALFirst renewal noticeBuilt 1976 · S/N 15079041 N714BERegistration Pending · Campbell Hall, NYRegistration pendingBuilt 1976 · S/N 15079044 N714BJChandler Scott G · Fortuna, CAFirst renewal noticeBuilt 1976 · S/N 15079047 N714BKZehner Mike W · Boise, IDS/N 15079048 N714BLPeery Harold R · Madill, OKBuilt 1976 · S/N 15079049 N714BNFly Low Aviation LLC · Smithville, MSS/N 15079051 N714BTZielke Michael M · Chuluota, FLBuilt 1976 · S/N 15079056 N714CABlue Steele LLC · Barnegat, NJBuilt 1976 · S/N 15079063 N714CCMckeon Kevin A · Center Moriches, NYS/N 15079065 N714CDVan Ooijen Herman J · Utica, NYBuilt 1976 · S/N 15079066 N714CEWade Bryan · Westfield, INBuilt 1977 · S/N 15079398 N714CFMuir Stephen G · Woodbridge, CABuilt 1976 · S/N 15079068 N714CHGo Leasing Co · Phillipsburg, KSFirst renewal noticeBuilt 1976 · S/N 15079070 N714CJSideline Services LLC · Pearland, TXS/N 15079071 N714CLStrategic Aircraft Management LLC · Fairbanks, AKS/N 15079073 N714CPWentzien Derald E · Newark, DEBuilt 1976 · S/N 15079076 N714CUWestlye Kenneth J · Micanopy, FLBuilt 1976 · S/N 15079081 N714CYGilman Yoel · Aurora, COBuilt 1976 · S/N 15079085 N714DDDunaire LLC · Mechanicsburg, PABuilt 1976 · S/N 15079089 N714DFOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1976 · S/N 15079091 N714DGParr Aviation LLC · Monrovia, MDBuilt 1976 · S/N 15079092

Back to AD 94-05-05 R1