Registered aircraft · 176

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:96-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-13') 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:96-10-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-13')
  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:96-10-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-13')
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.

N90FSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 31T-8020011 N90VMJ & B Leasing Inc · Springfield, MOBuilt 1981 · S/N 31T-8104031 N910AGCreative Marketing Associates Inc · Saint Petersburg, FLBuilt 1984 · S/N 31T-8004041 N910HGTiffin Aire Inc · Tiffin, OHS/N 31T-7400009 N910JPRegistered aircraftBuilt 1977 · S/N 31T-7820004 N913NCDeweese Michel J · Rockvale, TNBuilt 1981 · S/N 31T-8120044 N914ASRed Speakers LLC · Newark, DEBuilt 1981 · S/N 31T8104066 N916RTAasjng LLC · Holdrege, NEBuilt 1981 · S/N 31T-8166041 N917TPAerial LLC · Kalispell, MTBuilt 1982 · S/N 31T8104068 N918FMAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 31T-7904025 N9266YTiffin Aire Inc · Tiffin, OHS/N 31T-1104008 N937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeBuilt 1977 · S/N 31T-7720037 N93SHBasin Air LLC · Mattawa, WAFirst renewal noticeS/N 31T-7904029 N944GMSix States Rentals Inc · Union, MOBuilt 1978 · S/N 31T-7904005 N950CTJack Of Queens LLC · Afton, OKBuilt 1977 · S/N 31T-7720069 N950SACrop Dusters LLC · Maurice, IABuilt 1981 · S/N 31T-8166028 N96MAGoldielochs Air LLC · Annapolis, MDS/N 31T-7804005 N970PSKrech Greg Trustee · Huron, SDBuilt 1979 · S/N 31T-8020023 N977GUS Nameplate Co · Mount Vernon, IABuilt 1981 · S/N 31T-8104065 N980CATlh Enterprises Inc · Corsicana, TXBuilt 1980 · S/N 31T-8104010 N982KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 31T-7820011 N98FAHigher Purpose Aviaiton LLC · Spring Lake, MIBuilt 1980 · S/N 31T-8004028 N98TGBell Scott W · Greeley, COS/N 31T-7904027 N990LRDavis Aviation Inc · Brandon, MSBuilt 1978 · S/N 31T7820060 N998LMArmstrong Airlines Inc · Dover, DEBuilt 1980 · S/N 31T-8120006 N99VATwin Otter International Ltd · Las Vegas, NVBuilt 1976 · S/N 31T-7720007

Back to AD 96-10-13