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.

N730FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0477 N7315LSale Reported · Pelkie, MISale reportedBuilt 1987 · S/N 502-0006 N731FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0480 N731LCSchuman Carriage Company Ltd · Honolulu, HIBuilt 2005 · S/N 208B1137 N731LMStructure Studios LLC · Henderson, NVBuilt 2022 · S/N K036 N731PBBeaver Creek Aviation LLC · Perry, IABuilt 1980 · S/N 31T8166001 N732LCSchuman Carriage Co Ltd · Honolulu, HIBuilt 2005 · S/N 208B1149 N732MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 208B1083 N733CHAcc Integrated Services Inc · Milwaukee, WIBuilt 1987 · S/N SH-3733 N733PBw69 Air LLC · Fort Walton Beach, FLBuilt 2001 · S/N 4697052 N734CBGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N LJ-1508 N736WDCassil Robert B Trustee · San Francisco, CABuilt 2005 · S/N 20800392 N73LHWillow Shade Ltd · Englewood, COBuilt 2016 · S/N 20800588 N73PGFirst Financial Bankshares Inc · Abilene, TXBuilt 2000 · S/N LJ-1607 N73RARoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 110413 N73RFRandigo LLC · Wilmington, DEBuilt 1991 · S/N 208B0289 N73WCBrs 73wc LLC · Santa Ana, CABuilt 1996 · S/N FL-135 N740FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0484 N741FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0486 N744FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0492 N744MAOctane Addiction Aviation Inc · Augusta, GABuilt 2005 · S/N 46020073 N745FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0495 N746FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0498 N747FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0238 N747FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0501 N748FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0241 N748FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0503 N749FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0242 N74GCDiamond Bar LLC · Kirkland, WABuilt 1977 · S/N 559 N74GJSkydive Greene County · Xenia, OHBuilt 1961 · S/N BA-559 N74KSR & R Pallet Of Garden City · Garden City, KSBuilt 2000 · S/N FL-299 N74RFAir Flair Inc · Maurice, IABuilt 1983 · S/N 425-0153 N75Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-10 N7500SHill Ag-Air LLC · Bancroft, IDS/N 829B N75090Gasper Air Spray Inc · Crookston, MNBuilt 1992 · S/N 831B N7509VRichard Flying Service Inc · Rayne, LABuilt 1991 · S/N 828B N7509YAnderson'S Flying Service Inc · Yuba City, CABuilt 1992 · S/N 830B N750ABNpa Aviation LLC · Lafayette, LABuilt 1991 · S/N 4 N750DZBranded X LLC · Springfield, ORBuilt 2004 · S/N 108 N750FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0511 N750KAN750ka LLC · Wilmington, DEBuilt 1977 · S/N BB224 N750KPAircraft Structures International Corp · Enid, OKBuilt 1997 · S/N 208B0628 N750RCLuke & Payton LLC · Marianna, ARS/N LJ-640 N750SDSkydive Coolidge Inc · Tempe, AZBuilt 2004 · S/N 111 N750SSPacair LLC · Brookline, NHBuilt 2005 · S/N 115 N750TTDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N BB215 N750XLArne Aviation LLC · Suffolk, VABuilt 2004 · S/N 109 N750ZSouthern Airways Pacific LLC · Addison, TXBuilt 2004 · S/N 208B1054 N751FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0245 N751FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0514

Back to AD 2014-17-08 R1