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.

N965HLCaravan-International Leasing Inc · Carson City, NVBuilt 2001 · S/N 208B0901 N965SBFlynn Dog Aviation LLC · Port Charlotte, FLBuilt 2000 · S/N 4697015 N966FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0086 N966HLCaravan International Leasing Inc · Carson City, NVBuilt 1999 · S/N 208B0739 N967FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0088 N967HLCaravan International Leasing Inc · Carson City, NVBuilt 1995 · S/N 208B0426 N967TBJc Air Montana LLC · Missoula, MTBuilt 1967 · S/N 1669TB39 N968FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0090 N968TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 20800513 N968TXTexas Department Of Public Safety · Austin, TXBuilt 2024 · S/N 20800713 N969FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0092 N969JVGgm Transport LLC · Bakersfield, CABuilt 2022 · S/N 1440 N969MCMec International Trading LLC · Daytona Beach, FLBuilt 1999 · S/N 208B0765 N969PLUS Government · Washington, DCBuilt 2005 · S/N 208B1119 N969TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 20800532 N96FMYates Industries LLC · Artesia, NMBuilt 2001 · S/N 4697094 N96KKPro Serve Aviation LLC · Englewood, COBuilt 1980 · S/N LA104 N970FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0093 N970GRjc Aviation LLC · Morrow, OHBuilt 2001 · S/N 4697104 N970JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N LJ-1650 N971FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0094 N971NUS Government · Washington, DCS/N 208B1071 N971SCAxis Transportation Services LLC · Sacramento, CABuilt 1993 · S/N LJ-1343 N9720FUnited States Of America · Melbourne, FLBuilt 1989 · S/N 20800144 N972AAAfab Capital LLC · Oak Creek, WIBuilt 1989 · S/N SH 3754 N972FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0096 N9738BSensor Aircraft LLC · Plano, TXBuilt 1988 · S/N 208B0097 N973FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0098 N973GACentral Virigina Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N LJ675 N975TBMiles High Flight Assets LLC · Atlanta, GABuilt 1993 · S/N 75 N9760BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0102 N9761BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0107 N9762BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0109 N9766BRedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0112 N976EWright Air Service Inc · Fairbanks, AKBuilt 2002 · S/N 208B0976 N976FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0103 N977FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0104 N978JGColorado Orthopaedic Outreach Inc · Steamboat Springs, COS/N EA-637 N978TSWaxhaw Flyers LLC · Rosedale, MSBuilt 1997 · S/N FL-171 N979DKCatia Resources LLC · Garden City, TXBuilt 1985 · S/N FA-79 N979FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0228 N979SVSkydive Guam Inc · Barrigada, GUBuilt 2002 · S/N 208B-0979 N97WCHf Air LLC · Hattisburg, MSBuilt 1990 · S/N BB-1382 N97WELawrence Aviation Inc · Austin, TXBuilt 1997 · S/N BB-1586 N980FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0108 N980FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0489 N980MAFountainblu LLC · Wilmington, DEBuilt 2023 · S/N 4698283 N981FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0110 N981LLState Of Il Dot · Springfield, ILBuilt 1999 · S/N FL-265 N9820FPa1 208b-0410 LLC · Fort Lauderdale, FLBuilt 1994 · S/N 208B0410

Back to AD 2014-17-08 R1