OpenAirDocs.org
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.

N729BMAig Partners LLC · Carson City, NVBuilt 2017 · S/N 954N729CFWells Flying Services LLC · Holdrege, NEBuilt 2000 · S/N 802A-0101N729FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0474N729GTBig Sky Aviation LLC · Bozeman, MTBuilt 1996 · S/N FL-143N72FERegistered aircraftBuilt 2002 · S/N FL-344N72JDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-72N72KAKenmore Air Harbor LLC · Kenmore, WABuilt 1992 · S/N 208B0326N72LDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-19N72LXSapient Air LLC · Kirkland, AZBuilt 2020 · S/N LIV 213N72RARoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 110.377N72TTTarmac Turbo LLC · Issaquah, WABuilt 1956 · S/N 912N73Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-8N73005Mid Atlantic Ag LLC · Nassau, DEBuilt 1985 · S/N 400-0520N73006Mid Continent Aircraft Corp · Hayti, MOBuilt 1985 · S/N 400A-0501N7300EMark Gary Flying Service Inc · Inverness, MSBuilt 1984 · S/N 400-0517N7305GAerial Ag Services LLC · Hillsboro, TXBuilt 1985 · S/N 301-0603N73070Lake Air Service LLC · Jennings, LABuilt 1999 · S/N 502B-0540N7307TAas LLC · Ovid, MIBuilt 1985 · S/N 400-0610N73080Tall Towers Aviation Inc · Page, NDBuilt 1985 · S/N 400-0639N73084Precision Aerial Ag LLC · Seneca, KSBuilt 1985 · S/N 400-0638N73085Woodley Aerial Leasing LLC · Walnut, ILBuilt 1985 · S/N 301-0636N7308ADevil Dusters Inc · Artesia, NMBuilt 1985 · S/N 400-0624N730FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0477N730JDSky Tech Inc · Dorchester, NEBuilt 2012 · S/N 502B-2819N73127Georges Aircraft Repair · Vernon, TXBuilt 1987 · S/N 301-0667N7315LSale Reported · Pelkie, MISale reportedBuilt 1987 · S/N 502-0006N731FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0480N731LMStructure Studios LLC · Henderson, NVBuilt 2022 · S/N K036N731PBBeaver Creek Aviation LLC · Perry, IABuilt 1980 · S/N 31T8166001N732MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 208B1083N733CHAcc Integrated Services Inc · Milwaukee, WIBuilt 1987 · S/N SH-3733N733PBw69 Air LLC · Fort Walton Beach, FLBuilt 2001 · S/N 4697052N733RZ53kwd LLC · Austin, TXBuilt 2023 · S/N 100-0325N734CBGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N LJ-1508N736United States Dept Of The Interior · Boise, IDBuilt 2009 · S/N 100-0019N736LAFlatland Aviation LLC · Indianola, MSBuilt 2011 · S/N 502B-2736N736WDCassil Robert B Trustee · San Francisco, CABuilt 2005 · S/N 20800392N73EMMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2022 · S/N 100-0312N73LACameron Parish Mosquito Abatement · Creole, LABuilt 2006 · S/N 402B-1173N73PGFirst Financial Bankshares Inc · Abilene, TXBuilt 2000 · S/N LJ-1607N73PLP & L Aircraft Leasing Inc · Salem, OHBuilt 2012 · S/N EVO-032N73RARoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 110413N73RFRandigo LLC · Wilmington, DEBuilt 1991 · S/N 208B0289N73WCWest Coast Aircraft Sales LLC · Santa Ana, CABuilt 1996 · S/N FL-135N740FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0484N741FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0486N744FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0492N744MAOctane Addiction Aviation Inc · Augusta, GABuilt 2005 · S/N 46020073N745EALaurel Road Properties LLC · Morehead City, NCBuilt 2001 · S/N BB-1745N745FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0495
Back to AD 2002-23-13