Registered aircraft · 562

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:2002-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:2002-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:2002-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:2002-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:2002-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:2002-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.

N98GWKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N P-187 N98KARoyal Air Inc · Labelle, FLBuilt 1972 · S/N P-212 N98RETwin Star Hot Springs LLC · Hot Springs, ARBuilt 1977 · S/N TJ-108 N993CAPilot Air LLC · Owensboro, KYBuilt 1980 · S/N P-555 N999KTSmith John C B · West Palm Beach, FLS/N TJ-483 N999SWEis Equipment LLC · Eau Claire, WIBuilt 1979 · S/N P-505 N999WMTriple Nine Wm LLC · Yukon, OKBuilt 1978 · S/N P-472 N99JZUnadventurous LLC · Amarillo, TXBuilt 1984 · S/N TJ-474 N99PAMckelvey Jeffrey R · Dadeville, ALBuilt 1978 · S/N TJ-179 N9EPMcavian LLC · Perryton, TXBuilt 1981 · S/N TJ-378 N9JLGamble John W · Roswell, GABuilt 1975 · S/N P-352 N9NSTs&L Aircraft LLC · Alexandria, MNBuilt 1979 · S/N TJ-238

Back to AD 2002-10-13