AD 2000-22-03

Registered aircraft · 425

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:2000-22-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-03')
  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.

N212AGSea Aviation Holdings LLC · Wilmington, DEBuilt 2007 · S/N 258821N212XXLegacy Aviation Trust Holdings Corp · Edmond, OKS/N 257093N213RGGlobal Avionics LLC · Downey, CABuilt 1986 · S/N 258073N214TDHarbor Aircraft LLC · Wilmington, DEBuilt 1997 · S/N 258332N218PJSoany Steam Inc · Cheyenne, WYBuilt 1988 · S/N NA0426N218RXAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1996 · S/N 258323N220JJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 258475N220PFExecutive Air Taxi Corp · Bismarck, NDBuilt 2001 · S/N 258542N222PBBlanchard Aviation LLC · Albuquerque, NMBuilt 1999 · S/N 258443N224JL205 Flintstones LLC · Flint, MIBuilt 1995 · S/N 258279N22CPRegistered aircraftBuilt 2003 · S/N 258624N230TSDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N NA700N23CJGrzechowiak Gary L · Denison, TXS/N 25152N2409KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258601N240VN240v LLC · Wilmington, DEBuilt 1999 · S/N 258417N241JSE D Santos & Associates LLC Trustee · Wilmington, DES/N 258652N244FLAviation Leasing Group Inc · Wilmington, DES/N 258066N248ECEc Aviation LLC · Lake Oswego, ORBuilt 1998 · S/N 258368N24SMExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2002 · S/N 258567N250MBNo Layover LLC · Hays, KSBuilt 1993 · S/N 258237N254SBHawker 800xp LLC · Fort Lauderdale, FLBuilt 2003 · S/N 258616N257PLTavaero Jet Charter Corp · Houston, TXBuilt 1990 · S/N 258167N258MRE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1994 · S/N 258258N259RHAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258529N25XPRd Airways LLC · Channelview, TXS/N 258572N261PACalla Airways LLC · Cohasset, MABuilt 1998 · S/N 259003N263SNBlue Skies Hawker LLC · Whitefish, MTBuilt 2002 · S/N 258580N265JGShell Mountain Ranch LLC · Cranfills Gap, TXBuilt 2004 · S/N 258699N26MEJ Jets Inc · Los Angeles, CABuilt 1982 · S/N NA 0315N26TCAcme Nite LLC · Nashville, TNBuilt 2001 · S/N 258521N2766KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 258744N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693N2787Valiair Lc Trustee · Casper, WYBuilt 1984 · S/N 257208N279CFJ Jets Inc · Dover, DES/N 258642N285RAAsesu Aircraft LLC · Miami, FLS/N 258221N285XPAviation Fjaf LLC · Davie, FLBuilt 1995 · S/N 258285N28ZFCore Projects Inc · Fresno, CAS/N NA0458N298WB45 Srl Inc · Houston, TXBuilt 2000 · S/N 258476N3007Empire Airlines Inc · Lebanon, MOBuilt 2000 · S/N 258487N300CQHawker 4 LLC · Jensen Beach, FLBuilt 2001 · S/N 258555N304BHCalla Airwaysllc · Cohasset, MAS/N NA1003N307XPSkybridge Aviation Group Inc · Apopka, FLBuilt 1996 · S/N 258307N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665N310EJZenodro At Tranquility Aviation LLC · Clermont, FLBuilt 2006 · S/N 258767N311FLAlliance Aviation Group LLC · Wilmington, DEBuilt 1997 · S/N 258338N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545N312STexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1999 · S/N 258436N314TCTop Cat Aviation LLC · Pelham, ALBuilt 1999 · S/N 258400N315RCRocklyn National LLC · Syracuse, NYBuilt 2000 · S/N 258480N316MFMf Property Management LLC · Hattiesburg, MSS/N 258314
Back to AD 2000-22-03