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.

N44MBTria Entertainment LLC · Wisconsin Dells, WIBuilt 2002 · S/N 258573N44UNHawker 258359 LLC · Dover, DEBuilt 1998 · S/N 258359N457JAviation Leasing Group Inc · Wilmington, DEBuilt 1987 · S/N 258085N45GDPacific Rim Management LLC · Middletown, DEBuilt 1989 · S/N 258142N45KGAircraft Holding Solutions LLC · Newark, DEBuilt 1980 · S/N 257189N45KNHawker800xp LLC · Dorado, PRBuilt 2003 · S/N 258635N469RJDodson International Parts Inc · Rantoul, KSBuilt 1986 · S/N 258067N474CFCarrousel Aviation LLC · Monroe, WIBuilt 2004 · S/N 258662N475HMFalcon Double D 163 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258451N475RSRomeo Sierra LLC · Morgantown, WVBuilt 2004 · S/N 258674N47HAHoosier Jets LLC · Sellersburg, INBuilt 1995 · S/N 258280N47HWCelebration Tv America Inc · Houston, TXS/N 258023N488AMByte Me Transportation Inc · Fort Pierce, FLBuilt 2003 · S/N 258648N489BMEd Santos & Associates LLC Trustee · Wilmington, DEBuilt 1994 · S/N 258271N492DYLerma Aviation LLC · Dallas, TXBuilt 2001 · S/N 258546N499PANe Charters LLC · South Jordan, UTBuilt 2005 · S/N 258739N500XPHawker 800xp LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258455N509DMTeam Aero LLC · Shawnee, KSS/N 258056N50KLLiberty Leasing V LLC · Melbourne, FLBuilt 2004 · S/N 258671N511BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 259031N511JCIntermodal Air LLC · Frankfort, ILBuilt 2001 · S/N 258518N512JCCarr Air LLC · Cornelius, NCBuilt 2001 · S/N 258556N512WCCarr Air LLC · Cornelius, NCBuilt 2002 · S/N 258595N513BEH800 IV LLC · Stuart, FLBuilt 2000 · S/N 258471N515LRAviation Dynamics LLC · South Portland, MEFirst renewal noticeBuilt 1998 · S/N NA1006N516THHippo Air LLC · Grants Pass, ORBuilt 1999 · S/N 258418N518RRMidas Air Corp · Wilmington, DES/N NA0278N520LR1489 LLC · New York, NYFirst renewal noticeBuilt 1992 · S/N NA1008N520SBBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 259032N521JKSale Reported · Beverly Hills, CASale reported, canceledBuilt 1994 · S/N 258262N524LRUsac Airways 693 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 259-024N528MXCombined LLC · Helena, MTBuilt 2005 · S/N 258725N52SMWumac Inc · South Portland, MES/N NA1009N533LRAviation Dynamics LLC · South Portland, MEFirst renewal noticeBuilt 1992 · S/N 259033N540KTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2005 · S/N 258702N541LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 259041N541XPJoveros Aviation LLC · Miami, FLBuilt 2001 · S/N 258541N544LRAviation Dynamics LLC · South Portland, MEFirst renewal noticeBuilt 1994 · S/N 259044N544PSLucas Aviation LLC · Fremont, MIBuilt 2000 · S/N 258491N547LRAviation Dynamics LLC · Portland, MEFirst renewal noticeBuilt 1994 · S/N 259047N548LRAviation Dynamics LLC · South Portland, MEFirst renewal noticeBuilt 1995 · S/N 259048N552MEN552me LLC · Las Vegas, NVBuilt 2000 · S/N 258459N553BWHawker 800xp LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258570N55BAKarma55ba LLC · Stuart, FLS/N 258356N55LBPie High LLC · Atlanta, GABuilt 2000 · S/N 258494N55XPAtlas Leasing Partners LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258583N561PSTlc Aviation LLC · Bloomfield Hills, MIBuilt 1980 · S/N NA-0262N564BRKaleidoscope Charter Services Corp · Kansas City, MOS/N NA0287N565SKM&N Equipment LLC · Englewood, COBuilt 2002 · S/N 258604N567CLN567cl LLC · Dallas, TXBuilt 1993 · S/N 259035
Back to AD 2000-22-03