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.

N719HGFlightworks Inc · Kennesaw, GABuilt 2000 · S/N 258488N71AHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2004 · S/N 258654N724GPJawad A Shah Md Pc · Flint, MIS/N 258238N724JLAmeri Hawk Investments LLC · Lorton, VABuilt 2006 · S/N 258772N726LCN726lc LLC · Amarillo, TXBuilt 1998 · S/N 258349N728HHNevarez Julio · Brownsville, TXS/N 258166N729ATN88ca III LLC · Stuart, FLBuilt 1999 · S/N 258402N72FCAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258519N72HAMcn Aviation Partners LLC · Charlestown, INBuilt 2000 · S/N 258503N730CJN730cj LLC · Williamsburg, VABuilt 1992 · S/N NA1007N732AADjcj LLC · Nashville, TNBuilt 1993 · S/N 258243N740TTValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 258644N745MCMiradair LLC · Lake George, NYBuilt 2002 · S/N 258593N746TXSierra Aviation Holdings LLC · Colorado Springs, COBuilt 2005 · S/N 258746N7490ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N NA 0320N749WWSmf Ohio LLC · Lakewood, NJBuilt 2001 · S/N 258500N770CCTaughannock Aviation Corp · Ithaca, NYBuilt 2002 · S/N 258587N770RGAir Mccormack LLC · Chicago, ILBuilt 1993 · S/N 259025N771FMCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2002 · S/N 258591N777EHMilligan Michael Zachery · Reno, NVFirst renewal noticeS/N 257020N778RMAero Advantage Services Corp Trustee · Wilmington, DES/N 258178N780DWBemo23 Assembly LLC · New York, NYBuilt 1998 · S/N 258378N789HAClark County Jets LLC · Sellersburg, INBuilt 1998 · S/N 258354N793RCLfg Aviation Holdings LLC · Kalispell, MTBuilt 2001 · S/N 258550N798PAJli Holdings Group Inc · Johns Island, SCS/N 258070N799RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 258708N799SN143bl LLC · Hixson, TNBuilt 2002 · S/N 258588N79TSTasair LLC · Minocqua, WIBuilt 2001 · S/N 258511N800AFJec Hawker LLC · Pflugerville, TXS/N 258158N800CJCdmr Pj LLC · Jackson, NJS/N 258081N800EASalt Whistle LLC · Newark, DEBuilt 2002 · S/N 258582N800EGAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1990 · S/N 258182N800FJAstra Aircraft Holdings Corp · Wilmington, DES/N NA0428N800GNJaunt Jet LLC · Spring, TXBuilt 1998 · S/N 258372N800JMGreen Chair Productions Inc · Wichita Falls, TXS/N NA0421N800LQAdc Aviation LLC · Birmingham, ALBuilt 2001 · S/N 258551N800MAMarco Aviation LLC · Nazareth, PABuilt 1998 · S/N 258369N800NGClear Horizons LLC · Greenwood Village, COBuilt 2001 · S/N 258549N800NJGlobal Empire Trust LLC · Fort Lauderdale, FLBuilt 2000 · S/N 258483N800PAVance And Priscilla Hinton LLC · New Braunfels, TXS/N NA0438N800PEFour C Air Inc · Delano, CABuilt 2000 · S/N 258508N800PLN800pl LLC · Fort Lauderdale, FLS/N 258696N800RGRm13 Air LLC · Wellington, FLBuilt 1993 · S/N 258230N800SEDodson International Parts Inc · Rantoul, KSS/N NA0425N800SVAircraft Fidelity Corp Trustee · Dover, DES/N NA0470N800THHoover Aviation LLC · Nashville, TNBuilt 2004 · S/N 258678N800TLN800tl LLC · Wilmington, DEBuilt 1998 · S/N 258394N800UKJ W Construction Co Inc · Wise, VABuilt 2002 · S/N 258577N800UWUniform Whiskey Holdings LLC · Opa Locka, FLBuilt 1998 · S/N 258395N800VRCkv Express LLC · Minneapolis, MNBuilt 1984 · S/N 258016
Back to AD 2000-22-03