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.

N9634BMec International Trading LLC · Daytona Beach, FLBuilt 1988 · S/N 208B0141N963FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0080N963HLCaravan-International Leasing Inc · Carson City, NVBuilt 1988 · S/N 208B0101N963KAMeshoppen Air LLC · Tunkhannock, PABuilt 1977 · S/N LW242N964LBCoastal Aviation Group LLC · Panama City, FLBuilt 1991 · S/N FL59N9655BSkysno Aviation LLC · Snohomish, WABuilt 1989 · S/N 208B0145N965FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0084N965SBFlynn Dog Aviation LLC · Port Charlotte, FLBuilt 2000 · S/N 4697015N966FABoardman Air Service LLC · Henderson, NEBuilt 2022 · S/N 802-0966N966FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0086N966HLCaravan International Leasing Inc · Carson City, NVBuilt 1999 · S/N 208B0739N967FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0088N967HLCaravan International Leasing Inc · Carson City, NVBuilt 1995 · S/N 208B0426N967TBJc Air Montana LLC · Missoula, MTBuilt 1967 · S/N 1669TB39N9680BCatalina Air Transport LLC · Long Beach, CABuilt 1989 · S/N 208B0150N968FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0090N968LAC & L Holtzworth Inc · Virden, ILBuilt 2022 · S/N 802A-0968N969FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0092N969JVGgm Transport LLC · Bakersfield, CABuilt 2022 · S/N 1440N969PLUS Government · Washington, DCBuilt 2005 · S/N 208B1119N96CESummit Air Leasing LLC · Portage, MIBuilt 1996 · S/N BB-1536N96FMYates Industries LLC · Artesia, NMBuilt 2001 · S/N 4697094N96KKPro Serve Aviation LLC · Englewood, COBuilt 1980 · S/N LA104N970FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0093N970GRjc Aviation LLC · Morrow, OHBuilt 2001 · S/N 4697104N970JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N LJ-1650N970LAC&L Holzwarth Inc · Virden, ILBuilt 2022 · S/N 802A-0970N971FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0094N971NUS Government · Washington, DCS/N 208B1071N971SCAxis Transportation Services LLC · Sacramento, CABuilt 1993 · S/N LJ-1343N972AAAfab Capital LLC · Oak Creek, WIBuilt 1989 · S/N SH 3754N972FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0096N973AAAcc Integrated Services Inc · Milwaukee, WIBuilt 1988 · S/N SH3749N973FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0098N973GACentral Virigina Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N LJ675N975TBMiles High Flight Assets LLC · Atlanta, GABuilt 1993 · S/N 75N9760BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0102N9761BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0107N9762BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0109N9766BRedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0112N976EWright Air Service Inc · Fairbanks, AKBuilt 2002 · S/N 208B0976N976FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0103N976NMKlondike Ag LLC · Nassau, DEBuilt 2021 · S/N 802A-0908N977FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0104N977JBJb Leasing LLC · Norfolk, NEBuilt 2023 · S/N 802A-1038N977RMBretts Spray Service Inc · Onida, SDBuilt 2017 · S/N 802-0702N978JGColorado Orthopaedic Outreach Inc · Steamboat Springs, COS/N EA-637N978TSWaxhaw Flyers LLC · Rosedale, MSBuilt 1997 · S/N FL-171N979DKCatia Resources LLC · Garden City, TXBuilt 1985 · S/N FA-79N979FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0228
Back to AD 2016-05-13