Skip to content

AD 2014-17-08 R1

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.

N860AR412 Jw Aviation LLC · Dover, DEBuilt 1990 · S/N 36019 N860FWFlorida Fish And Wildlife Conservation Commission · Lakeland, FLBuilt 2023 · S/N 20800699 N861FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0183 N861MAAerodynamics Worldwide Inc · Wilmington, DEBuilt 2000 · S/N 208B0825 N861PPIrlbeckbruch Plane LLC · York, NEBuilt 2003 · S/N 510 N861ZGGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-493 N862FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0184 N863FEFederal Express Corp · Memphis, TNBuilt 1989 · S/N 208B0186 N863MAMartinaire Aviation LLC · Addison, TXBuilt 2004 · S/N 208B1049 N864SFAlaska Skypower LLC · Fairbanks, AKBuilt 2000 · S/N 208B0864 N865FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0188 N865HPRustair Inc · Anchorage, AKBuilt 1998 · S/N 20800289 N865MASchuman Carriage Co Ltd · Honolulu, HIBuilt 2002 · S/N 208B0996 N866FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0189 N866KMMac Aviation LLC · Fargo, NDBuilt 2003 · S/N 528 N867FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0191 N867HPCaravan International Leasing Inc · Carson City, NVBuilt 1991 · S/N 208B0252 N868SDBig Wings LLC · Sheridan, WYBuilt 2021 · S/N 20800681 N869FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0195 N869XATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0869 N86RFRandigo LLC · Wilmington, DEBuilt 1985 · S/N 20800033 N870A & S Aviation LLC · Chesterfield, MOBuilt 1993 · S/N 607 N870FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0196 N871FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0198 N872FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0200 N873FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0202 N874FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0205 N875DMKilo Alfa 200 LLC · Bakersfield, CABuilt 1990 · S/N BB-1354 N875FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0206 N875MRMarc Aircraft Holding LLC · Soldotna, AKBuilt 2009 · S/N 208B2079 N875RJUS Air Force Special Operations Command/A5km · Hurlburt Field, FLS/N 646 N875SHJrm Aero LLC · Joplin, MOBuilt 2004 · S/N 4697174 N87699Pjh Consulting LLC · Reno, NVBuilt 1981 · S/N BB-887 N876FEFederal Express Corporation · Memphis, TNS/N 208B0207 N878FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0211 N878KWehco Newspapers Inc · Little Rock, ARBuilt 1998 · S/N LJ-1513 N878PNPenny Newman Grain Co · Fresno, CABuilt 2023 · S/N 4698251 N879FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0213 N87AWSummit Leasing LLC · Kenai, AKBuilt 1954 · S/N 52 N87JFIsr Aviation LLC · Wilmington, DEBuilt 1998 · S/N 208B0657 N87RMRegistration Pending · Lebanon, MERegistration pendingBuilt 1988 · S/N 208B0114 N87SALiberty Air LLC · Christiansted, VIFirst renewal noticeBuilt 1982 · S/N BB-1089 N87VDynamic Avlease Inc · Bridgewater, VAS/N LM-130 N8800Tvs Aviation LLC · Nashville, TNBuilt 2001 · S/N 202 N880DTOklahoma Department Of Transportation · Oklahoma City, OKBuilt 1991 · S/N LJ-1288 N880FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0215 N8817QRuhe Sales LLC · Leipsic, OHBuilt 1970 · S/N 1517R N881FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0204 N882FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0208 N883CRHoffman Travis K · Maroa, ILS/N 83

Back to AD 2014-17-08 R1