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.

N827DLGa Ventures LLC · Scott, LABuilt 1986 · S/N FA-103 N828BFlight First LLC · Ixonia, WIBuilt 2010 · S/N 20800514 N828DCHnl 208 LLC · Honolulu, HIBuilt 2009 · S/N 208B2074 N828FCGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1436 N828FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0122 N828SSSusanaire LLC · Dallas, TXBuilt 1986 · S/N BB-1252 N829JPMicronesian Air Cargo Services (Cnmi) LLC · Saipan, MPBuilt 2013 · S/N 208B2429 N829MCKidd Johnston Aviation LLC · Odessa, TXBuilt 2000 · S/N BB-1708 N829SJInternational Air Services Inc Trustee · Carson City, NVBuilt 2012 · S/N EVO-0037 N82AXBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N K121 N82CXEpic Aircraft LLC · Bend, ORBuilt 2020 · S/N K004 N82LHAirborne Support Group LLC · Marion, MTBuilt 1969 · S/N 208 N82RFRandigo LLC · Wilmington, DEFirst renewal noticeBuilt 1985 · S/N 20800124 N82XLFast Fly Inc · Dallas, TXBuilt 1981 · S/N 31T-8166034 N83110Jones Aviation Inc · Biggs, CAS/N 11D N831FEFederal Express Corporation · Memphis, TNS/N 208B0225 N831VFEpic Aircraft LLC · Bend, ORBuilt 2021 · S/N K014 N8347KPorter Flying Service LLC · Missoula, MTBuilt 1980 · S/N 22D N835MABank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 208B2335 N838GVTatonduk Outfitters Ltd DBA · Fairbanks, AKS/N 208B0838 N839MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2392 N83FTR E E Inc · Beaumont, TXBuilt 1998 · S/N BB-1621 N83GTChambliss Aerobatics LLC · Chandler, AZBuilt 2001 · S/N 46-97032 N83PWMotion Skies LLC · Rocky Mount, NCBuilt 1987 · S/N BB-1283 N83RWEhr Ventures LLC · Jourdanton, TXBuilt 1991 · S/N LJ-1271 N83WEMiner'S Inc · Hermantown, MNBuilt 1978 · S/N LW-289 N840CAMetrea Special Aerospace Isr Inc · Bethany, OKS/N FL-104 N840JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1985 · S/N 20800056 N840MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2423 N841FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0144 N841KYPinaire Holdings LLC · Hendersonville, TNS/N BB-841 N842EBIsr Aviation LLC · Wilmington, DEBuilt 1989 · S/N 208B0146 N843BHGaylord Theodore Scott DBA · La Grange, CABuilt 2001 · S/N 196 N843DBDoan Creek LLC · Walla Walla, WABuilt 1978 · S/N 31T-7820090 N843FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0147 N843SASpirit Air Inc · Salmon, IDBuilt 2002 · S/N 208B0930 N844FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0149 N845FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0152 N846BEM D Airways Inc · Derby, KSBuilt 1984 · S/N FA-16 N846DJHeritage Aviation Management Ltd · Conroe, TXBuilt 1992 · S/N FM-7 N846FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0154 N846RDRegistration Pending · Naples, FLRegistration pendingBuilt 2004 · S/N 4697186 N847BABeech Transportation Inc · Eden Prairie, MNBuilt 1981 · S/N BB847 N847CPFedair LLC · Indianapolis, INBuilt 2001 · S/N 4697080 N847FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0156 N848FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0158 N84BDWhite Birch Transportation · Lee, NHBuilt 2002 · S/N 20800353 N84FCWilliams Fertilizer Services LLC · Oregon, MOBuilt 1994 · S/N 402-0946 N84HSGc N84hs LLC · Layton, UTS/N 50 N85022Bergo LLC · Harrisburg, ARBuilt 2001 · S/N 402A-1140

Back to AD 2014-17-08 R1