AD 89-22-16

Registered aircraft · 1,050

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

N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLBuilt 1996 · S/N 650-7067N125SBBay Venture Management LLC · Atlanta, GABuilt 1985 · S/N 258046N125TKSupreme Sky LLC · Farmers Branch, TXBuilt 1994 · S/N 247N125XPN125xp LLC · Wilmington, DEBuilt 2000 · S/N 258485N126KLAircraft Fidelity Corp Trustee · Dover, DEBuilt 1984 · S/N 096N127VLE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1991 · S/N 036N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212N129GBCapital Cost Corp · Wilmington, DEFirst renewal noticeBuilt 1983 · S/N 650-0006N12RPRoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 278N12SYMcwalsh LLC · Dover, DEBuilt 1987 · S/N 258103N130YBMwl Aviation 1 LLC · Miami Lakes, FLBuilt 2002 · S/N 258590N132CESouthern Energy Transport LLC · Shelbyville, TNBuilt 1995 · S/N 650-7061N133EJHale William Trustee · Loveland, COBuilt 1977 · S/N 133N133KSJyh Aviation LLC · Jacksonville, FLBuilt 2004 · S/N 258697N135SHMed Air LLC · Wilmington, DEBuilt 1981 · S/N 335N136JPCasmos LLC · Wilmington, DES/N 35A-359N137SHDream Global Parts LLC · Lawrence, KSS/N 137N139LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 139N13ADN13ad LLC · Dover, DES/N 030N140WHVarney Aviation LLC · Bangor, MEBuilt 1991 · S/N 650-0195N141AELake Superior College · Duluth, MNBuilt 1981 · S/N NA0306N141JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 2010N143LJBchjet3 LLC · Greer, SCS/N 143N145LRCalchem Transportation LLC · Stockton, CABuilt 2000 · S/N 119N146EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 146N147GXAltair Aviation LLC · Missoula, MTBuilt 1987 · S/N 214N14NAAnschutz Corp · Englewood, COBuilt 1992 · S/N 124N14PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 258317N150EXDodson International Parts Inc · Rantoul, KSS/N 262N150JGHardaway Capital Group One LLC · Stateline, NVBuilt 1992 · S/N 233N150SBRegistration Pending · Anchorage, AKRegistration pendingBuilt 1991 · S/N 258197N152FJVictory Outreach International · San Dimas, CABuilt 1984 · S/N 152N154LAAnschutz Corp · Englewood, COBuilt 1982 · S/N 127N154RRN154rr LLC · Wilmington, DEBuilt 1998 · S/N 258375N155ERAir Medical Services LLC · Denver, NCBuilt 1984 · S/N 55-098N156NSNunya LLC · Costa Mesa, CABuilt 2004 · S/N 258668N156REOnward & Upward Aviation LLC · Lake Mary, FLBuilt 1985 · S/N 156N158ECHhh Aviation LLC · Des Moines, IABuilt 2001 · S/N 186N159RABar Aircraft Leasing LLC · Waterford, MIBuilt 1975 · S/N 024N15BADodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 020N15RKPlane Part Solutions LLC · Lake Park, FLBuilt 1996 · S/N 258297N15VXTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1985 · S/N 158N161SDSierra Delta Aviation LLC · Boise, IDBuilt 1996 · S/N 650-7066N163CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 163N163JMGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1988 · S/N 650-0163N164GBNewcastle Capital Group LLC · Dallas, TXBuilt 1986 · S/N 164N166RARoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 449N166RLLm Aeropsace Corp · Deerfield Beach, FLBuilt 1990 · S/N 047N167BRHhf Aviation LLC · Nashville, TNBuilt 1981 · S/N 42N16LJLear Holding Corp · Wilmington, DEBuilt 1986 · S/N 126
Back to AD 89-22-16