OpenAirDocs.org
AD 2013-22-21

Registered aircraft · 2,381

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

N166AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52496N166MSFlyone USA Corp · Miami, FLS/N 1078N16715Cahaba Forestry Services LLC · Flowood, MSBuilt 1976 · S/N 2110N16726Aeroag Asset LLC · Edgerton, MOBuilt 1976 · S/N 2122N16760Riggs Bobby W · Lake Mary, FLBuilt 1977 · S/N 45081N16770R & T Aviation LLC · Ethel, LABuilt 1977 · S/N 2147N16810Southern Helicopter Services Inc · Millington, TNBuilt 1977 · S/N 2231N16832Orgis B J · Hallettsville, TXBuilt 1977 · S/N 2243N168STMotor Heads Inc · Blairstown, NJBuilt 1977 · S/N 2566N168TBSouthwest Aviation Enterprises · Haslet, TXBuilt 2000 · S/N 53434N16929Reynolds Darryl G · Wills Point, TXBuilt 1978 · S/N 2314N16979Withrotor Aviation Inc · Lakeview, ORS/N 2346N169AAPierce Associates LLC · Prineville, ORBuilt 1973 · S/N 990N169RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52063N16SPState Of New York · Albany, NYBuilt 2002 · S/N 53532N170AMPremier Rotors LLC · Saint Martinville, LABuilt 1982 · S/N 51036N171WHWestwind Helicopters Inc · Santa Fe, TXBuilt 1997 · S/N 53149N17238Bennett Aviation LLC · Lafayette, LABuilt 1991 · S/N 51492N173MSFlorida Keys Mosquito Control District · Marathon, FLBuilt 2000 · S/N 52256N173PStarflite Helicopters LLC · Beaufort, NCS/N 51370N173RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52066N173SFGm Leasing Company LLC · Broussard, LAS/N 53978N1751Gm Leasing Co LLC · Broussard, LABuilt 1981 · S/N 3284N17592Premier Rotors LLC · Saint Martinville, LAS/N 51535N175MSFlorida Keys Mosquito Control District · Marathon, FLBuilt 2006 · S/N 52326N175PAMansfield Helifight · Milton, VTBuilt 1997 · S/N 53154N176AEAir Evac Ems Inc · Ofallon, MOBuilt 1979 · S/N 45224N176PGreenfield Kevin G Trustee · Anchorage, AKS/N 4219N176PDElon Management LLC · Salem, ORBuilt 2008 · S/N 4658N178PAOrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45319N179RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52102N179SFN179sf LLC · Chandler, AZBuilt 1996 · S/N 53196N17DEBell Textron Inc · Fort Worth, TXBuilt 2006 · S/N 53700N17DFDf Aviation LLC · Somerset, KYS/N 54922N17NRTrans 5 Investments LLC · Saint Martinville, LABuilt 1972 · S/N 786N17NXTrans 5 Investments LLC · Saint Martinville, LAS/N 3040N17SPNew York State Police · Albany, NYBuilt 2000 · S/N 53444N17TLTurbines Ltd · West Point, NEBuilt 1992 · S/N 51603N17TWWhirlybird Aviation LLC · Bend, ORBuilt 1998 · S/N 52213N1807Gm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 52361N181MAMinuteman Aviation Inc · Missoula, MTBuilt 2007 · S/N 53789N1821Gm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 52366N182AAIndustrial Helicopters LLC · Lafayette, LABuilt 1979 · S/N 2752N183DHSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 2410N183TCLarson Dylan J · Perham, MNS/N 1805N184AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54044N184SFGm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53087N189AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54047N189RLL&R Investment Partners LLC · Wilmington, DES/N 2210N18BHAbc Helicopters Inc · Jefferson, WIBuilt 1997 · S/N 53217
Back to AD 2013-22-21