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.

N696JMFalcon Aviation Services LLC · Dallas, TXBuilt 1987 · S/N 28N699BGWord Of Life Christian Center Inc · Darrow, LAFirst renewal noticeBuilt 1990 · S/N 082N700FLFl Aircraft LLC · North Little Rock, ARBuilt 2006 · S/N 170N700PGAviation Xx LLC · Wilmington, DEBuilt 2004 · S/N 137N700SWSafeway Leasing Inc · Westmont, ILBuilt 2008 · S/N 203N70BRRegistered aircraftBuilt 2000 · S/N 63N70FKChildress Klein Management Services LLC · Charlotte, NCBuilt 2015 · S/N 293N70LFWind Turbine And Energy Cables Corp · Hasbrouck Heights, NJBuilt 1996 · S/N 09N70TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 102N711FJBirner Aviation LLC · Earth City, MOBuilt 1989 · S/N 071N711RWAuto & Otolar LLC · Lawrence, KSBuilt 1989 · S/N 69N711TJCenturion Investments Inc DBA · Chesterfield, MOBuilt 1996 · S/N 06N711TQGrey Falcon LLC · Ewing, NJBuilt 2013 · S/N 276N711WHKcm Ventures Whitefish 2 LLC · Arlington, TXBuilt 1999 · S/N 56N711WVRoss Airplane LLC · Parkersburg, WVBuilt 1997 · S/N 166N716BHM Hixson Aviation LLC · Lake Dallas, TXBuilt 1997 · S/N 22N716GTS5 Aviation LLC · Longview, TXBuilt 1997 · S/N 168N717LAAdcnt Management Co LLC · Dallas, TXBuilt 1998 · S/N 35N719SHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 119N720MLNorthwestern Mutual Life Insurance Co · Milwaukee, WIBuilt 2009 · S/N 231N721FHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 028N72PSCool Grove Equipment LLC · Fort Lauderdale, FLBuilt 2015 · S/N 290N746ARJdm Aircraft LLC · Arlington, TXS/N 63N754JLNewport Blue LLC · Corona Del Mar, CABuilt 1989 · S/N 54N754MMKings Aviation Corp · Garden City, NYBuilt 1988 · S/N 064N75ABRivers Equipment III LLC · Nashville, TNBuilt 2001 · S/N 94N75KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 299N7600PSas Institute Inc · Cary, NCBuilt 2009 · S/N 226N7600SSas Institute Inc · Cary, NCBuilt 2006 · S/N 173N763UGray & Company Inc · Metairie, LABuilt 2008 · S/N 193N767WBScandere LLC · Waukesha, WIBuilt 1993 · S/N 132N76FDGrindstone Aviation LLC · New Castle, DEBuilt 2008 · S/N 216N775GMGlobus Aviation LLC · Audubon, PABuilt 1993 · S/N 134N777XYCair Leasing LLC · Wilmington, DEBuilt 1987 · S/N 27N780SPScashley Falcon LLC · Los Angeles, CABuilt 1991 · S/N 93N782RP399 Air LLC · Fort Lauderdale, FLBuilt 1992 · S/N 116N7883KRegistered aircraftBuilt 2008 · S/N 198N78CYWkc Corp · Saint Louis, MOBuilt 2000 · S/N 79N790LTGbl LLC · Woodbury, MNBuilt 1993 · S/N 129N790TN16fx Trust · Wilmington, DEBuilt 2008 · S/N 621N79LE206 Holdings LLC · New Orleans, LABuilt 1997 · S/N 16N7BD757bd LLC · Albuquerque, NMBuilt 1987 · S/N 31N7KCFalcon 200 Inc · Nashville, TNBuilt 1997 · S/N 14N800DWJfm Air II LLC · Wilton Manors, FLS/N 79N800KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1993 · S/N 120N805ALScashley Falcon LLC · Portland, MEBuilt 1988 · S/N 35N808SFTgs Logistics LLC · Dover, DEBuilt 1997 · S/N 013N812PMEl Jefe Express II LLC · Lake Forest, ILS/N 127N818THWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 169N81HMIheart Media Management Services Inc · New York, NYBuilt 2000 · S/N 183
Back to AD 2002-23-20