Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N9730GMcginty Flying Service LLC · Jones, LAS/N 18052230 N9730XHaase Herman · Stockton, CABuilt 1962 · S/N 21058030 N9731XPoe David A · Big Sandy, TXBuilt 1962 · S/N 21058031 N9732GFulcher David B · Glendale, AZBuilt 1971 · S/N 18052232 N9733GZimmitti Andrew · Mclean, VAS/N 18052233 N9733HStephens Jack J · Kingwood, TXBuilt 1981 · S/N 18267980 N97345Postupack Peter Jr · New Cumberland, PABuilt 1979 · S/N 18267063 N9735XPascal LLC · Des Moines, WAS/N 21058035 N97361Sky 4 Me LLC · Greendale, WIS/N 18267067 N97365Sugg Robert Michael · Covington, GABuilt 1979 · S/N 18267069 N9736BWrigley David C · Anchorage, AKBuilt 1964 · S/N 50034 N9736GBrakey Richard F · Amarillo, TXBuilt 1972 · S/N 18052236 N9736HBrentco Aerial Patrol Inc · Canton, OHBuilt 1981 · S/N 18267983 N9736MRyan Air Inc · Anchorage, AKBuilt 1981 · S/N 20700722 N9737GZamoruev Alexander Vladimirovich Trustee · Anchorage, AKBuilt 1972 · S/N 18052237 N9737HXyz Aviation LLC · Rineyville, KYBuilt 1981 · S/N 18267984 N97380Rsf Services LLC · Salem, ORBuilt 1979 · S/N 18267073 N97385182q LLC · Tyler, TXS/N 18267076 N97386Ratcliffe & Sons Inc · Madill, OKS/N 18267077 N9738HBallard Bradley J · Youngsville, NCBuilt 1981 · S/N 18267985 N9738XAdelman Timothy B · Stevensville, MDBuilt 1961 · S/N 21058038 N97396Sds Aviation Inc · Buford, GABuilt 1979 · S/N 18267079 N97398Dbat Flying Club LLC · Reno, NVBuilt 1979 · S/N 18267080 N9739GBjork Richard J · Brackettville, TXBuilt 1972 · S/N 18052239 N973JMMarc Inc · Bolton, MSBuilt 1978 · S/N 18266734 N973SRRegistration Pending · Kuna, IDRegistration pendingBuilt 1968 · S/N 18258865 N9740GKestrel Kat LLC · Wilmington, DEBuilt 1972 · S/N 18052240 N97410Skynuke LLC · Bechtelsville, PABuilt 1979 · S/N 18267082 N97413Northwoods Air LLC · Orono, MEBuilt 1979 · S/N 18267083 N9741XHalbert Larry E · Jacksonville, FLBuilt 1961 · S/N 21058041 N9742HSingularity - Intelligence Amplified LLC · Conesus, NYBuilt 1981 · S/N 18267989 N97433Menyhay William Csaba · Clovis, CABuilt 1979 · S/N 18267090 N97435Wipaire Inc · South Saint Paul, MNBuilt 1979 · S/N 18267091 N97437Carr Jeffrey A · Worthington, KYS/N 18267093 N97443Miller Charles L Jr · Eunice, LABuilt 1979 · S/N 18267095 N97446Mpm Wizard Enterprise LLC · Hawthorne, CAFirst renewal noticeBuilt 1979 · S/N 18267096 N97452Taylor Michael Riding · Friday Harbor, WAFirst renewal noticeBuilt 1979 · S/N 18267099 N97453Stofer William B · Warsaw, INBuilt 1979 · S/N 18267100 N97456Harrington Co · Butte, MTBuilt 1979 · S/N 18267101 N97467Kg Rentals LLC · Edmond, OKBuilt 1979 · S/N 18267104 N97469Wooten James E · Avinger, TXBuilt 1979 · S/N 18267105 N9746XAgent West Insurance Inc · Hurricane, UTBuilt 1962 · S/N 21058046 N9746YAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1981 · S/N 21064585 N97485Strong Neil E · Pittsburg, TXBuilt 1979 · S/N 18267109 N97487Bruns Gregg R · West Chester, OHBuilt 1979 · S/N 18267110 N9748GKlamar Spraying Inc · Gatzke, MNBuilt 1972 · S/N 18052248 N9748ZKerr Kenneth E · Bakersfield, CAS/N 21060943 N9749BLee Norman S · Green Valley, AZBuilt 1957 · S/N 50047 N9749XNeal Daniel A · Winchester, TNBuilt 1962 · S/N 21058049 N974PCMontana Bizjets LLC · Missoula, MTBuilt 1997 · S/N 18280076

Back to AD 84-10-01 R1