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

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

N149XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 27149 N225PGAero 7 LLC · Doral, FLS/N 25247 N253GCAerway Capital Management LLC · Waterford, WIS/N 25303 N263LMVent Airlines Inc · Dover, DEBuilt 1994 · S/N 26603 N311GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1995 · S/N 26316 N313XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25313 N314XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25314 N403YKNorthern Air Cargo LLC · Anchorage, AKBuilt 1992 · S/N 25842 N405CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1991 · S/N 25407 N405YKNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1991 · S/N 25267 N406CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1997 · S/N 28752 N409YKAircraft 25859 LLC · Lake Mary, FLBuilt 1993 · S/N 25859 N440KHAircraft 28889 LLC · Lake Mary, FLBuilt 1998 · S/N 28889 N442KHAircraft 28888 LLC · Lake Mary, FLBuilt 1998 · S/N 28888 N640CSCsds Asset Management LLC · Marana, AZS/N 26078 N652EEAerotrust Services Corp Trustee · Wilmington, DEBuilt 1992 · S/N 26526 N732CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1989 · S/N 24271 N733CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1992 · S/N 25849 N734CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1993 · S/N 25858 N803TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 27156 N804TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1989 · S/N 23988 N806TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1992 · S/N 27081

Back to AD 2016-01-05