Registered aircraft · 2,524

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

N994DF5 Blade Aero LLC · Firestone, COBuilt 1991 · S/N 22 N994FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0132 N994FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2315 N9956BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0119 N995FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0133 N995MKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1990 · S/N 180 N995SPmg-Sr22t LLC · Greenville, NCBuilt 2003 · S/N 4697154 N996FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0135 N996QCHds Inc · Beech Grove, ARS/N 19C N997FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0197 N997LMLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1976 · S/N BB217 N998FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0139 N999FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0231 N999FNWing Air LLC · Orinda, CABuilt 2022 · S/N K033 N999NGLiadair Inc · Wilmington, NCBuilt 2000 · S/N 4697022 N999RWFederal Investors Servicing Corp · Capitan, NMBuilt 2001 · S/N 4697037 N999VBJet Air Inc · Galesburg, ILBuilt 1995 · S/N BB-1506 N999WVWright Air Service Inc · Fairbanks, AKBuilt 2009 · S/N 208B2082 N99ACRejo Inc · Wilmington, DEBuilt 1974 · S/N LW-120 N9GAN9ga Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1719 N9GTRedemption Inc · Kodiak, AKBuilt 1989 · S/N 20800153 N9MSModification Specialists LLC · Johnson, KSS/N 001 N9NXTalkeetna Aero Services Inc · Anchorage, AKS/N 20800129 N9UEDakota Commercial & Development · Grand Forks, NDBuilt 2002 · S/N 224

Back to AD 2014-17-08 R1