Registered aircraft · 29

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-04-03') 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-04-03') 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-04-03')
    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-04-03')
  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-04-03')
  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-04-03')
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.

N1502TFights Mitchell · Kellyville, OKBuilt 1982 · S/N 11124 N1508WBaker Carmen W · Lexington, NCBuilt 1982 · S/N F7B-002 N1510CPortland Rose Balloons LLC · Wilsonville, ORS/N F7B-011 N1511YWildung Michael P · Newton, IABuilt 1982 · S/N F7B-025 N1512MAdler David M · Yuma, AZBuilt 1982 · S/N F7B-031 N1514CWolfson Alan B · Loveland, OHBuilt 1983 · S/N F7B-040 N15193De Koevend Enterprises Inc · Fort Garland, COBuilt 1981 · S/N 10969 N1524UGoodman Travis W · Amarillo, TXS/N 10311 N1524VHooper Kirk M · Albuquerque, NMBuilt 1981 · S/N 10319 N1526UPayne Ralph J · Hastings, MIBuilt 1981 · S/N 11103 N1544UBouton Vern H · Fairbanks, AKBuilt 1981 · S/N 10270 N1544YTannehill Theodore J · Howard, OHBuilt 1981 · S/N 10268 N2080CCaputo Joseph A · Pittston, MEBuilt 2006 · S/N F7B-2013 N21046Harrison Stephen R · Murray, UTBuilt 2006 · S/N F7B-2012 N21941Suskin Dan · Atlanta, GABuilt 2004 · S/N F7B2011 N3601MGear Robert L III · Paradise Valley, AZBuilt 1983 · S/N F7B-044 N3608YHolland Benjamin M · Gladstone, MOS/N F7B-067 N3668FBruce Bailey L H · Raleigh, NCBuilt 1983 · S/N F7B-085 N36931Kinser Aviation LLC · Guthrie, OKS/N F7B-109 N37443Engleman Mark T · Indianapolis, INS/N F7B-093 N37517Sanborn Lee M · Alto, MIBuilt 1983 · S/N F7B-094 N69WMBalloon Meadows Inc · Clinton Corners, NYBuilt 1983 · S/N F7B-068 N7106ENiccum Jonathan S · Hampden, MABuilt 1987 · S/N F7B-134 N71106Sena Paul A · Worthington, MAS/N F7B-136 N7407KSky Adventures Inc · Oxford, MIS/N F7B-118 N7407PLeonard Ian Q · Burlington, NCS/N F7B-129 N74114Yachik Jeremy · Greeley, COS/N F7B-122 N90643Aeronautical Adventures Inc · Eagle, IDS/N F7B-305 N93PZThurman Joshua T · Limestone, TNS/N F7B-363

Back to AD 84-04-03