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.

N751KCJ A Peterson Enterprises Inc · Shawnee Mission, KSBuilt 1980 · S/N LJ-887 N752FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0247 N752FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0517 N752MMMc Aviation LLC · Fort Lauderdale, FLBuilt 2004 · S/N 4697192 N753CAMoon Mountain Montana LLC · Missoula, MTBuilt 2000 · S/N 163 N753FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0520 N754FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0526 N754KPKalinin Partners LLC · Juneau, AKBuilt 2007 · S/N 208B1264 N755DMMdst Aircraft Leasing LLC · Ripon, WIBuilt 1994 · S/N 101 N755FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0529 N755KPKalinin Partners LLC · Juneau, AKBuilt 1999 · S/N 208B0759 N7580BMec International Trading LLC · Daytona Beach, FLBuilt 1987 · S/N 208B0051 N7581FDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1994 · S/N 208B0389 N758KCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ316 N75AWSemper Blue Aviation LLC · New Braunfels, TXBuilt 1981 · S/N 42-8001046 N75GMMandes George J · Homer, AKBuilt 2010 · S/N 20800518 N75LVCook Childrens Health Enterprises · Fort Worth, TXS/N BB-1075 N75LW4t Aviation LLC · Maypearl, TXBuilt 1973 · S/N LW-75 N75MSDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N LA204 N75PGDasch Air LLC · Alamo, CABuilt 1995 · S/N LJ-1390 N75ZDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-61 N760JEIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1997 · S/N 760462 N761CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1994 · S/N 760410 N761FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0254 N762FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0255 N763FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0256 N7644SIslander Holdings Ltd · Ft Lauderdale, FLS/N 760314 N765FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0259 N767FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0262 N767TPNuage Holdings LLC · Sioux Falls, SDBuilt 2001 · S/N 4697036 N768FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0263 N768SXRentco LLC · Deer Park, TXFirst renewal noticeBuilt 1991 · S/N 760372 N769FXFederal Express Corp · Memphis, TNBuilt 2024 · S/N 408-0030 N769JSSpurlock Benjamin · Eugene, ORBuilt 2001 · S/N 187 N76AZHubbard Broadcasting · Saint Paul, MNBuilt 1988 · S/N 20800139 N76CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1989 · S/N 760355 N76DNFastboy Equipment LLC · Beasley, TXS/N 760351 N76EXIsland Express Helicopters Inc · Henderson, NVBuilt 1988 · S/N 760342 N76FLHelinet Aviation Services LLC · Van Nuys, CABuilt 1988 · S/N 760347 N76GMDodson International Parts Inc · Rantoul, KSS/N LJ-498 N76KAKenmore Air Harbor LLC · Kenmore, WABuilt 1958 · S/N 300 N76MGCook Brothers Farms LLC · Princeton, KYBuilt 2001 · S/N 4697056 N76PM2012 Leasing Inc · Saint Paul, MNBuilt 1998 · S/N FL-200 N76QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-15 N770DCRam Aviation LLC · Alexandria, LABuilt 2000 · S/N 183 N770FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0265 N770FLTailwinds Aviation LLC · Wilmington, DEBuilt 2003 · S/N 501 N770VFGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1641 N771MGEaglemed LLC · Wichita, KSBuilt 1998 · S/N BB-1636 N772AAPro-Air LLC · Alexandria, LABuilt 2004 · S/N 502B-0691

Back to AD 2014-17-08 R1