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.

N681ZLZulu Lima LLC · Marshfield, MABuilt 2009 · S/N 210N684KFJcg Aviation LLC · Park Ridge, ILBuilt 2003 · S/N 213N685KFJcg Aviation LLC · Park Ridge, ILBuilt 2006 · S/N 230N688CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 241N68HCHca Squared LLC · Nashville, TNBuilt 2019 · S/N 355N690SPRegistered aircraftBuilt 2016 · S/N 334N695PPilot 1958 LLC · Knoxville, TNBuilt 2014 · S/N 722N69FHCarol 1 LLC · Nashville, TNBuilt 2004 · S/N 039N700DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 63N702AKMatapalo Holdings LLC · Hialeah, FLBuilt 2012 · S/N 259N702NWNext Wave Aviation LLC · Henderson, NVBuilt 2001 · S/N 170N703PPOvation Jet Parts LLC · Dover, DES/N 70N704JDClear Horizon Investments LLC · Overland Park, KSBuilt 2002 · S/N 178N705WLAspen Peak LLC · Houston, TXBuilt 2002 · S/N 187N707BEMoonraker Aviation LLC · Blacksburg, VABuilt 1995 · S/N 07N707MTMt 7 Aircraft LLC · Dallas, TXBuilt 2005 · S/N 57N709DPWilmington Trust Co Trustee · Wilmington, DES/N 251N70LXLimerick Aviation LLC · Denver, COBuilt 2007 · S/N 131N70TFRex Realty Co · Saint Louis, MOBuilt 2014 · S/N 272N710ETQuack Quack LLC · Portland, ORBuilt 1996 · S/N 38N713AGAgee Richard E · Houston, TXBuilt 2014 · S/N 289N714JBOjw LLC · Wilmington, DES/N 18N715CBPilot 1958 LLC · Knoxville, TNBuilt 2015 · S/N 311N717TFRegistered aircraftBuilt 2006 · S/N 100N71949Wilshire Rental Corp · Dallas, TXBuilt 2019 · S/N 356N719MCCdm Leasing LLC · Shelby Township, MIBuilt 2019 · S/N 746N720WYIron Bar Enterprises LLC · Hampstead, NCBuilt 2009 · S/N 189N722FSBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 64N722JBClos De Berry Leasing Ltd · New Carlisle, OHBuilt 1995 · S/N 13N729FSRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 2005 · S/N 063N72TVTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 433N733AHumana Inc · Louisville, KYBuilt 2011 · S/N 235N733HHumana Inc · Louisville, KYBuilt 2010 · S/N 219N733KHumana Inc · Louisville, KYBuilt 2016 · S/N 323N73FJTla73 LLC · Santa Rosa Beach, FLBuilt 1999 · S/N 73N745CXCdmorg Inc · Little Rock, ARBuilt 2005 · S/N 55N748REHawk Air LLC · Waukegan, ILBuilt 2013 · S/N 708N748RMInterbank · Dover, DEBuilt 2013 · S/N 713N74XPN74xp LLC · Tualatin, ORBuilt 2003 · S/N 04N750JEJae Aviation LLC · Englewood, COBuilt 1997 · S/N 53N759QWorking Group LLC · Sarasota, FLBuilt 2015 · S/N 301N75EKInto Air Aviation LLC · Clearwater, FLBuilt 2009 · S/N 172N75ENCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 363N7600GSas Institute Inc · Cary, NCBuilt 2011 · S/N 234N767LDCaribbean Ops LLC · Dover, DEBuilt 2000 · S/N 131N769JWRegistered aircraftBuilt 2009 · S/N 205N76BBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 47N771BVBbs I LLC · Vancouver, WABuilt 2006 · S/N 106N771HMHmhc Inc · Plymouth Meeting, PABuilt 2014 · S/N 279N774GHNext Generation Pdx LLC · Oregon City, ORBuilt 2003 · S/N 209
Back to AD 2002-23-19