AD 2016-05-13

Registered aircraft · 3,126

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
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:2016-05-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
  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.

N825SDGreat Valley Management Inc · New Castle, DEBuilt 1996 · S/N LJ-1449N826FPMango Air 2 LLC · Oxnard, CABuilt 2000 · S/N FL-284N826XTransport Services LLC · Birmingham, ALBuilt 1985 · S/N 826N827DLGa Ventures LLC · Scott, LABuilt 1986 · S/N FA-103N828FCGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1436N828GBG B Aerial Applications Inc · Slaton, TXBuilt 1997 · S/N 802A0052N828PGPowell 737pg LLC · Baton Rouge, LABuilt 1999 · S/N FL-232N828SSSusanaire LLC · Dallas, TXBuilt 1986 · S/N BB-1252N829MCKidd Johnston Aviation LLC · Odessa, TXBuilt 2000 · S/N BB-1708N829RTMcclendon Services LLC · Marianna, ARBuilt 2023 · S/N 802A-1010N829SJInternational Air Services Inc Trustee · Carson City, NVBuilt 2012 · S/N EVO-0037N82AXBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N K121N82CXEpic Aircraft LLC · Bend, ORBuilt 2020 · S/N K004N82LHAirborne Support Group LLC · Marion, MTBuilt 1969 · S/N 208N82XLFast Fly Inc · Dallas, TXBuilt 1981 · S/N 31T-8166034N83110Jones Aviation Inc · Biggs, CAS/N 11DN831FEFederal Express Corporation · Memphis, TNS/N 208B0225N831LAAg Concepts Inc · Morgan City, MSBuilt 2023 · S/N 802A-1031N831VFEpic Aircraft LLC · Bend, ORBuilt 2021 · S/N K014N8347KPorter Flying Service LLC · Missoula, MTBuilt 1980 · S/N 22DN835ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 802A-0887N838RAT206 Aviation LLC · Stockton, CAS/N 71N839FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2023 · S/N 802A-1042N83FTR E E Inc · Beaumont, TXBuilt 1998 · S/N BB-1621N83GTChambliss Aerobatics LLC · Chandler, AZBuilt 2001 · S/N 46-97032N83PWMotion Skies LLC · Rocky Mount, NCBuilt 1987 · S/N BB-1283N83RWEhr Ventures LLC · Jourdanton, TXBuilt 1991 · S/N LJ-1271N83WEMiner'S Inc · Hermantown, MNBuilt 1978 · S/N LW-289N840CAMetrea Special Aerospace Isr Inc · Bethany, OKS/N FL-104N840JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1985 · S/N 20800056N841BFWells Flying Services LLC · Holdrege, NEBuilt 2020 · S/N 802A-0821N841FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0144N841KYPinaire Holdings LLC · Hendersonville, TNS/N BB-841N841LABank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 502A-2841N842EElectric Boat Corp · Groton, CTBuilt 1998 · S/N UE-336N842EBIsr Aviation LLC · Wilmington, DEBuilt 1989 · S/N 208B0146N842KAKh Aviation LLC · Langdon, NDBuilt 2015 · S/N 802A-0599N843BHGaylord Theodore Scott DBA · La Grange, CABuilt 2001 · S/N 196N843DBDoan Creek LLC · Walla Walla, WABuilt 1978 · S/N 31T-7820090N843EElectric Boat Corp · Groton, CTBuilt 1998 · S/N UE339N843FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0147N844FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0149N845FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0152N846BEM D Airways Inc · Derby, KSBuilt 1984 · S/N FA-16N846DJHeritage Aviation Management Ltd · Conroe, TXBuilt 1992 · S/N FM-7N846FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0154N846RDRegistration Pending · Naples, FLRegistration pendingBuilt 2004 · S/N 4697186N847BABeech Transportation Inc · Eden Prairie, MNBuilt 1981 · S/N BB847N847CPFedair LLC · Indianapolis, INBuilt 2001 · S/N 4697080N847FAAerial Crop Services LLC · East Prairie, MOBuilt 2020 · S/N 802-0847
Back to AD 2016-05-13