AD 2002-23-19

Registered aircraft · 486

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

N775STDxp Holdings Inc · Houston, TXBuilt 1997 · S/N 43N777Erebus LLC · Tampa, FLBuilt 2003 · S/N 22N77FWestrock Group LLC · Little Rock, ARBuilt 1997 · S/N 51N77QETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 77N783FSFarspo LLC · Oklahoma City, OKBuilt 1976 · S/N 09N785ADCs Investments LLC · Dallas, TXBuilt 2008 · S/N 146N787FRFurniture Row Leasing LLC · Denver, COBuilt 1999 · S/N 80N789JCMajjec Holdings LLC · Newark, DEBuilt 2007 · S/N 128N78FJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 78N790RTnc Management V LLC · Phoenix, AZBuilt 2011 · S/N 225N790Z2514 LLC · Dover, DEBuilt 1996 · S/N 31N793CGN793wf Lease LLC · Santa Ana, CABuilt 2015 · S/N 318N793KKJc Aviation LLC · Tucson, AZBuilt 2009 · S/N 202N797HDMario Murillo Ministries · Lafayette, TNBuilt 2000 · S/N 135N797LDThomas Aviation LLC · Wichita, KSBuilt 1996 · S/N 24N797PGEndless Aviation LLC · Buna, TXBuilt 2006 · S/N 90N797TWMulti-State Realty Investments LLC · Yukon, OKBuilt 2000 · S/N 111N797WCLand Sea Air Leasing Corp · Sylmar, CABuilt 2001 · S/N 140N799RBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 71N79TFBaron & Budd P C · Dallas, TXBuilt 2020 · S/N 373N800GHLeading Edge LLC · Minneapolis, MNBuilt 1999 · S/N 89N801WC986 Pb LLC · Portland, ORBuilt 2003 · S/N 21N801WWMountshore Capital LLC · Pompton Plains, NJBuilt 2011 · S/N 226N802CCOklahoma Steel & Wire Co LLC · Madill, OKBuilt 2021 · S/N 376N803PHPost Foods LLC · Chesterfield, MOBuilt 2012 · S/N 255N805DBDb Service Company LLC · Centennial, COBuilt 2008 · S/N 143N808VJVee-Jay Equipment LLC · Clarkston, MIBuilt 2014 · S/N 273N80BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 254N80MHFalcon 2000 (Msn 108) Leasing LLC · New York, NYBuilt 2000 · S/N 108N80RPRich Aviation Inc · Buffalo, NYBuilt 2007 · S/N 116N810ETMillrock Aviation Financial LLC · Danbury, CTBuilt 2010 · S/N 190N812RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 295N813VTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 196N818LWLeveled Wings LLC · Calabasas, CABuilt 2000 · S/N 126N822NPProductivity Strategies LLC · Olathe, KSBuilt 1993 · S/N 001N826APApi Aviation LLC · New Brighton, MNBuilt 2007 · S/N 0123N827UBcu 2000 LLC · Pleasant Prairie, WIBuilt 2020 · S/N 748N831DRDriscolls Inc · Watsonville, CABuilt 2008 · S/N 141N831MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 430N833JBImt Holdings Management Co LLC · Sherman Oaks, CABuilt 2004 · S/N 033N844UPUnion Pacific Railroad Co · Omaha, NEBuilt 2014 · S/N 287N845UPUnion Pacific Railroad Co · Omaha, NEBuilt 2014 · S/N 727N846UPUnion Pacific Railroad Co · Omaha, NEBuilt 2015 · S/N 729N84PJHampton Airways Inc · Sellersburg, INBuilt 2015 · S/N 303N850TCRt Falcon Enterprises LLC · Bloomfield Hills, MIBuilt 1999 · S/N 92N851MJet Plane Management LLC · Saint Paul, MNBuilt 2014 · S/N 293N855DGDollar General Corp · Goodlettsville, TNBuilt 2006 · S/N 97N855TJLark Aviation LLC · Reno, NVS/N 19N857SSSimon Aviation LLC · Birmingham, MIS/N 192N85HDHomerlease Co Inc · Atlanta, GABuilt 2024 · S/N 416
Back to AD 2002-23-19