AD 2002-23-20

Registered aircraft · 384

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-20')
    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-20')
  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.

N900SBBg Air LLC · Hobbs, NMBuilt 1991 · S/N 107N900SFFalcon 900 LLC · Mount Laurel, NJBuilt 1987 · S/N 16N900SLLima Tango Leasing Inc · Wichita, KSBuilt 2009 · S/N 227N900SNSn117 LLC · Great Neck, NYBuilt 2002 · S/N 117N900TEFalcon 900 LLC · Ocala, FLBuilt 1986 · S/N 12N900TNRegistered aircraftBuilt 1996 · S/N 158N900VCFalcon-121 LLC · Salem, ORBuilt 1992 · S/N 121N900VGVecellio Management Services Inc · West Palm Beach, FLBuilt 2014 · S/N 286N900VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 609N900VPJdr 194 LLC · Woody Creek, COBuilt 2002 · S/N 194N900WGGreenleaf Corp · Saegertown, PABuilt 1998 · S/N 33N900WKRegistered aircraftBuilt 2008 · S/N 210N900XYArchitectural Air II LLC · Washington, DCBuilt 2001 · S/N 86N900YBBold Access LLC · Leawood, KSBuilt 1987 · S/N 18N900YGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 246N900YPVillages Equipment Co · Leesburg, FLBuilt 2002 · S/N 114N900YYBbps Aviation LLC · Mckinney, TXBuilt 1991 · S/N 101N901FHCcbcc Operations LLC · Charlotte, NCBuilt 2023 · S/N 331N901KRAvatar Wings LLC · Dallas, TXBuilt 1994 · S/N 146N901MMUsonia Ventures LLC · Palo Alto, CABuilt 1997 · S/N 21N902YPVillages Equipment Co · Leesburg, FLS/N 092N904NBNewell Brands Inc · Atlanta, GAS/N 174N904YPVillages Equipment Co · Leesburg, FLBuilt 2002 · S/N 104N905FJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 1986 · S/N 5N905YPVillages Equipment Co · Leesburg, FLBuilt 2013 · S/N 263N908SBFalcon Hunter LLC · Houston, TXBuilt 2000 · S/N 81N909CKDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 42N90FJWorldwide Aircraft Services Inc DBA · Tampa, FLBuilt 1998 · S/N 75N90GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N 29N90THJ & J Capital Ventures LLC · Wilmington, DEBuilt 1999 · S/N 180N90YCAmerican Cruise Lines Inc · Guilford, CTBuilt 2010 · S/N 250N910NMTriangle Real Estate LLC · Saint Peters, MOS/N 95N910SCSunchasing LLC · Newark, DEBuilt 1994 · S/N 144N910TX900 Consulting LLC · Austin, TXBuilt 1998 · S/N 172N912BDBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 162N914SSMeregrass Inc · Dublin, TXBuilt 2001 · S/N 188N914TV1365 Swan Ridge Road LLC · New York, NYBuilt 1987 · S/N 14N915TPGlobe Resources Group LLC · Wichita, KSBuilt 1992 · S/N 122N917BCFlyaway Inc · Fort Worth, TXS/N 193N917JFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1999 · S/N 179N918JM999 Aviation LLC · Northbrook, ILBuilt 2008 · S/N 199N918MVGuardian Aviation Services LLC · Short Hills, NJBuilt 1996 · S/N 156N919SACsc Delaware Trust Co Trustee · Wilmington, DES/N 124N91MSLabbe LLC · Huntington Valley, PABuilt 1987 · S/N 10N921TBBluemaxx Air LLC · Friendswood, TXS/N 85N926JTVanderpenn LLC · Big Sky, MTBuilt 2014 · S/N 283N927AACapital Holdings 238 LLC · Waco, TXBuilt 1999 · S/N 046N927BRFur Management & Consulting LLC · Junction, TXBuilt 2002 · S/N 196N940CLDfn26pa LLC · Plymouth, MABuilt 1998 · S/N 031N942SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 622
Back to AD 2002-23-20