OpenAirDocs.org
AD 89-11-07

Registered aircraft · 22

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

N151Tatonduk Outfitters Ltd · Fairbanks, AKS/N 45179N3047VTatonduk Outfitters Ltd · Fairbanks, AKS/N 44658N400UATatonduk Outfitters Ltd · Fairbanks, AKBuilt 1954 · S/N 44258N401USCorsair Two LLC · Hillsboro, ORBuilt 1957 · S/N 45145N434TABank Of Utah Trustee · Salt Lake City, UTBuilt 1954 · S/N 44-434N43872Alaska Aviation Museum · Anchorage, AKS/N 53-3294N444CEEverts Air Fuel Inc · Fairbanks, AKBuilt 1958 · S/N 45478N4887CDelta Air Transport Heritage Museum DBA · Atlanta, GAS/N 45351N555SQTatonduk Outfitters Ltd · Fairbanks, AKBuilt 1957 · S/N 45137N578ASNighthawk Air Systems Inc · Miami, FLS/N 44650N600UARace Coast Aviation LLC · Port Orange, FLBuilt 1956 · S/N 44894N6353CCorsair Two LLC · Hillsboro, ORBuilt 1958 · S/N 45486N651CEEverts Air Fuel Inc · Fairbanks, AKBuilt 1958 · S/N 45501N6586CEverts Air Fuel Inc · Fairbanks, AKBuilt 1957 · S/N 45222N70BFFlorida Air Transport Inc · Miami Lakes, FLBuilt 1953 · S/N 43720N751CEEverts Air Cargo · Fairbanks, AKS/N 45177N777EAMissionary Wings Inc · Litchfield Park, AZS/N 45549N7780BEverts Air Fuel Inc · Fairbanks, AKBuilt 1957 · S/N 45372N7919CEverts Air Fuel Inc · Fairbanks, AKBuilt 1959 · S/N 43554N838DCorsair Two LLC · Hillsboro, ORBuilt 1958 · S/N 45347N851CEEverts Air Cargo · Fairbanks, AKS/N 45531N9056RTatonduk Outfitters Ltd · Fairbanks, AKBuilt 1958 · S/N 45498
Back to AD 89-11-07