AD 2002-23-13

Registered aircraft · 3,462

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:2002-23-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:2002-23-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.

N960FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0075N960GRomeo & Juliet Travel LLC · Danbury, CTBuilt 2002 · S/N 4697120N960HLCaravan-International Leasing Inc · Carson City, NVBuilt 1991 · S/N 208B0251N9612BAvion Capital Corp · Anchorage, AKBuilt 1988 · S/N 208B0136N961FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0077N961HLCaravan International Leasing Inc · Carson City, NVBuilt 1988 · S/N 208B0076N9621GSummer Agro Services LLC · Royal Palm Beach, FLBuilt 2011 · S/N 502B-2742N9623BRedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0138N962FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0078N962HLCaravan International Leasing Inc · Carson City, NVBuilt 1999 · S/N 208B0779N962SPKodiak Aircraft Co Inc · Sandpoint, IDBuilt 2026 · S/N 100-0372N9634BMec 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 4697015N966FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0086N966HLCaravan International Leasing Inc · Carson City, NVBuilt 1999 · S/N 208B0739N966JBRoth Aerial Spraying LLC · Milford, NEBuilt 2013 · S/N 502B-2885N967FEFederal 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 208B0090N969FEFederal 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 4697094N96JCAdonai International Ministries · Marine, ILFirst renewal noticeBuilt 1988 · S/N 858N96KKPro Serve Aviation LLC · Englewood, COBuilt 1980 · S/N LA104N96MBBorner Michael E Trustee · Easton, MDBuilt 2018 · S/N LJ-2157N96SDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LU-13N96YDynamic Avlease Inc · Bridgewater, VABuilt 1970 · S/N LU-8N970FEFederal 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-1650N971FEFederal 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 LJ675N974JBSeubert Enterprise Inc · Cottonwood, IDBuilt 2009 · S/N 100-0014N975SPSky Power LLC · Albuquerque, NMBuilt 1977 · S/N LW-263
Back to AD 2002-23-13