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.

N92KMJohnson Airspray Inc · Argyle, MNBuilt 1992 · S/N T41-175DC N92RKSnk Real Property Holdings LLC · Meta, MOBuilt 1996 · S/N LJ-1458 N9304FSkydive Baltimore LLC · Lincoln, DEBuilt 1985 · S/N 20800008 N930CFHynes Kevin P · Wichita Falls, TXBuilt 2016 · S/N 1157 N930DSAc Aircraft Holdings LLC · Dallas, TXBuilt 1999 · S/N FL-252 N930FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0030 N930HMForgenie Alan Peter · Willsboro, NYBuilt 2005 · S/N 4697236 N930MQGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1463 N9310FPa1 208b-0490 LLC · Fort Lauderdale, FLBuilt 1995 · S/N 208B0490 N9314FMission Aviation Fellowship · Nampa, IDBuilt 1985 · S/N 20800010 N931FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0031 N931GGPc Aviation LLC · Albany, GABuilt 1999 · S/N LJ-1572 N932CRedding Aero Enterprises Inc · Redding, CABuilt 1987 · S/N 208B0032 N9331BMartinaire Aviation LLC · Addison, TXBuilt 1987 · S/N 208B0055 N933RTZito Aviation LLC · La Salle, COS/N BB-955 N934FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0034 N935AMAirmed International LLC · Birmingham, ALBuilt 1994 · S/N LJ-1356 N935BDDiamond Aviation LLC · Dublin, GABuilt 1996 · S/N FL-155 N935FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0035 N936FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0036 N937CKSchuman Carriage Company Ltd · Honolulu, HIBuilt 2005 · S/N 208B1118 N937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeBuilt 1977 · S/N 31T-7720037 N938BSBlue Star Gas Fleet Services Co · Santa Rosa, CABuilt 2000 · S/N FL-287 N938JWMhs Airplane LLC · Augusta, GABuilt 2000 · S/N 46-97023 N938SBCavu 350 LLC · Stuart, FLBuilt 1998 · S/N FL-211 N939FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0180 N93ABernhard Leasing LLC · Ashland, OHBuilt 1973 · S/N LW-63 N93STZ Air LLC · Lynbrook, NYBuilt 2023 · S/N 4698272 N940FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0040 N941ATBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1942 · S/N 12907 (42-93040)N9421FJst Management LLC · Zephyrhills, FLS/N 20800049 N942CEVoice Of Evangelism Outreach Ministries · Cleveland, TNBuilt 2000 · S/N BB-1731 N943FEFederal Express Corporation · Memphis, TNS/N 208B0043 N943XCCircle C Aviation II LLC · Okeechobee, FLBuilt 1991 · S/N FL-60 N944CWby Enterprises II LLC · Jackson, TNBuilt 2001 · S/N BB-1749 N944XCMojave Jet LLC · Nolensville, TNS/N FL-281 N9452BAirspeed Aviation LLC · Tacoma, WABuilt 1988 · S/N 208B0123 N9454BAirspeed Aviation LLC · Tacoma, WABuilt 1988 · S/N 208B0072 N9469BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0079 N946FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0048 N946JJBetten Equipment Leasing Inc · Grand Haven, MIBuilt 1995 · S/N 115 N9471BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0081 N947AMDavis Aviation Inc · Brandon, MSBuilt 1990 · S/N LJ-1238 N947FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0050 N9481FIsr Aviation LLC · Wilmington, DEBuilt 1985 · S/N 20800070 N948AMGuardian Flight LLC · South Jordan, UTBuilt 1989 · S/N LJ-1210 N94JDGap Air Inc · Johnstown, PABuilt 1981 · S/N LA-139 N94PEHouston Thrush Aircraft Salvage Inc · Houston, TXBuilt 1994 · S/N T34-202 N94ZL9zl Leasing LLC · Plover, WIBuilt 1994 · S/N 502B-0241 N9505BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0085

Back to AD 2014-17-08 R1