OpenAirDocs.org
AD 89-22-01 R1 L

Registered aircraft · 1,179

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-01-R1-L')
    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-01-R1-L')
  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.

N412KKElkhorn Aviation Inc · Baker City, ORS/N 45277N413TVTri Rotor Spray & Chemical · Ulysses, KSBuilt 1981 · S/N 45636N4155KPereira Alfred R Jr · Valley Springs, CAS/N 1053N4180FCaswell Farms · Durham, CABuilt 1991 · S/N 51469N418SVCanyon Creek Investments Llp · Sapulpa, OKBuilt 1978 · S/N 2399N419DHAerial Applicators Of Missouri LLC · Qulin, MOBuilt 1984 · S/N 51007N41EWMemphis Police Department · Memphis, TNBuilt 1989 · S/N 4044N41PHTobler Hans P · Anchorage, AKBuilt 1974 · S/N 1544N41SJMti Travel Inc · Fountain Hills, AZBuilt 1974 · S/N 1352N4227EMonarch Enterprises Inc · Kirkland, WABuilt 1981 · S/N 45702N422RHJames V Paige Jr Development Corp · Bemus Point, NYBuilt 1981 · S/N 3249N422SDParker Helicopter LLC · Watsonville, CABuilt 1973 · S/N 1093N4237MTrideca Vertical Solutions LLC · Dallas, TXBuilt 1989 · S/N 4055N4282ZSayre Stanley · Mantua, OHBuilt 1999 · S/N 51499N429CEDelcamp Michael · Richmond, TXS/N 2806N429ZACoastal Air Service Inc · Panama City, FLBuilt 1980 · S/N 45375N43142Scotts Helicopter Services Inc · Le Sueur, MNBuilt 1977 · S/N 1577N431CAChem-Air LLC · Shreveport, LABuilt 1978 · S/N 2517N4328Air Gov II LLC · Rome, NYBuilt 1994 · S/N 4328N432TVSky Choppers LLC · Seneca, KSBuilt 1981 · S/N 3286N4338DAce High Helos LLC · Louise, TXBuilt 1992 · S/N 51560N433HAHelo N433ha LLC · Richmond, VABuilt 1981 · S/N 3431N43681World Trade Enterprises LLC · Lucas, TXS/N 773N43AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45187N43HHJohnson Flying Service LLC · Exira, IABuilt 1975 · S/N 1585N4445HBell Textron Inc · Fort Worth, TXBuilt 1998 · S/N 4493N444TVScotts Helicopter Service Inc · Le Sueur, MNBuilt 1981 · S/N 3501N4452Bravo Aviation LLC · Chicago, ILBuilt 1973 · S/N 1086N447JBJbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45415N448EAEdgefield Aviation LLC · Sandy, ORBuilt 1974 · S/N 1495N449EAEdgefield Aviation LLC · Sandy, ORBuilt 1982 · S/N 51027N449SS & L Farm And Ranch LLC · Georgetown, TXBuilt 1998 · S/N 4495N44BCRiggs Rock A · Lake Mary, FLBuilt 1976 · S/N 1904N452MCCitrus County Mosquito Control District · Lecanto, FLBuilt 1995 · S/N 4377N453RARanger Aviation Leasing LLC · Wilmington, DEBuilt 1981 · S/N 3453N454MSCb Couch Inc · Walcott, ARBuilt 1975 · S/N 1627N455TVCox Paul G DBA · Bryce, UTS/N 2796N4569U S Army · Ft Rucker, ALBuilt 2006 · S/N 5306N461RARanger Aviation Leasing LLC · Wilmington, DES/N 45461N463RARanger Aviation Leasing LLC · Wilmington, DEBuilt 1997 · S/N 4463N468RLMarks Lloyd L · Lafayette, LABuilt 1985 · S/N 51155N4717WSeven Whiskey LLC · Austin, TXS/N 51124N472MRight Brother Aviation LLC · Chaffee, NYBuilt 1994 · S/N 4327N476KAN476ka LLC · Wasilla, AKS/N 1953N477SDHigh-Lead Helicopters LLC · Mossyrock, WABuilt 1990 · S/N 51343N47HHJkt LLC · Douglas, WYS/N 2667N4833Gm Leasing Co LLC · Broussard, LABuilt 1989 · S/N 51285N483RVan Horn Aviation LLC · Tempe, AZBuilt 1969 · S/N 483N4846G M Leasing Co LLC · Broussard, LABuilt 1987 · S/N 51200N48552Brown Helicopter Inc · Pensacola, FLBuilt 2001 · S/N 5275
Back to AD 89-22-01 R1 L