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.

N41783Fpg Agri Services LLC · Frost, TXBuilt 1987 · S/N T-34-092DCN417ARGreenway Air LLC · Orlando, FLS/N 611N417KCFeatherstone Two LLC · Tampa, FLBuilt 2001 · S/N 417N41854Alpha Ag Air LLC · Little River, KSBuilt 2008 · S/N 502B-2624N4185LWdw Aviation Leasing Inc · Knoxville, TNBuilt 2000 · S/N 4697025N418AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 1977 · S/N 521N418JCsk Aviation Partners LLC · Fort Smith, ARBuilt 2000 · S/N BB-1705N4191YPake Flying Service LLC · Felton, MNBuilt 2000 · S/N T660-108N41991Bravo Gildardo F · Mission, TXBuilt 2008 · S/N 502B-2623N419FFMccreary Flying Service LLC · Clarksdale, MSS/N 802A-0191N419MNSouthern Justice Aviation LLC · Houston, TXBuilt 1980 · S/N BB-785N41JDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-89N41MKEric Leasing LLC · London, KYBuilt 2023 · S/N 4698247N4200SWood Flying Inc · Panhandle, TXBuilt 2008 · S/N 502B2625N42086Beta Ag Inc · Ralls, TXBuilt 2008 · S/N 502B-2637N420SAKingrey William S III · Richmond, TXBuilt 1990 · S/N 402-0776N4215WAero Applicators Inc · Sterling, COBuilt 2009 · S/N 402B-1211N4216KBecker Barton C · Oneill, NES/N 402A-1219N42190Matecumbe Flying Service Inc · Immokalee, FLS/N 502B-2705N421CAD&D Aerial LLC · Gratiot, WIBuilt 2009 · S/N 502B-2672N4220WRegistered aircraftBuilt 2010 · S/N 502B-2696N4222ATenax Air LLC · Ridgeland, MSBuilt 2001 · S/N UE-422N4223GTowe Flying Service · Madison, ALBuilt 2009 · S/N 502B-2675N422ASAmerican Aviation Inc · Brooksville, FLBuilt 2004 · S/N LJ-1714N422PMDale Aviation Inc · Rapid City, SDBuilt 1995 · S/N LJ1412N422RDAir-Sprayers Inc · Two Buttes, COBuilt 2009 · S/N 402B-1224N423MGMike Gulf LLC · Fort Lauderdale, FLBuilt 1996 · S/N 140N424EMDale Aviation Inc · Rapid City, SDBuilt 1993 · S/N LJ-1351N424SGAt Holdco LLC · San Antonio, TXBuilt 2001 · S/N 4697039N425BAMarchetti 211 LLC · Alva, OKS/N 4250046N425BFBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2014 · S/N 502B-3018N425BMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 4250190N425BPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N BB-1773N425CQHeritage On Lanier Inc · Gainesville, GABuilt 1983 · S/N 425-0173N425DRAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1984 · S/N 4250199N425DVVerner David W · Mcalester, OKBuilt 1985 · S/N 425-0232N425EMVfr Air LLC · Tifton, GABuilt 1982 · S/N 425-0164N425FZN425fz Corp Trustee · Wilmington, DEBuilt 1981 · S/N 425-0059N425GCResiak LLC · Middleton, WIBuilt 1981 · S/N 425-0027N425HJApd Development LLC · Palatine, ILBuilt 1984 · S/N 425-0169N425JESaturn International LLC · Cheyenne, WYBuilt 1981 · S/N 4250008N425KCWheels Up Aviation LLC · Mount Horeb, WIBuilt 1982 · S/N 425-0174N425KSSwja LLC · Haymarket, VABuilt 1981 · S/N 425-0102N425LCGlyde Aviation LLC · Canton, MABuilt 1981 · S/N 4250054N425NPGec Air LLC · Sellersburg, INBuilt 1985 · S/N 4250224N425REAccutherm Refrigeration Inc · Seal Beach, CABuilt 1982 · S/N 425-0167N425TFArminair Leasing LLC · Dover, DEBuilt 1981 · S/N 425-0143N425TJAddie Air Inc · Bridgeport, TXBuilt 1981 · S/N 425-0114N425TPRc Construction Co · Greenwood, MSBuilt 1984 · S/N 425-0213N425TTN425tt Corp Trustee · Wilmington, DEBuilt 1981 · S/N 425-0044
Back to AD 2002-23-13