OpenAirDocs.org
AD 81-18-01 R1

Registered aircraft · 1,016

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

N41EWMemphis 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 4055N429CEDelcamp 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 2517N4328Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1994 · S/N 4328N432TVSky Choppers LLC · Seneca, KSBuilt 1981 · S/N 3286N433HAHelo 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 1495N449SS & 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 4463N472MRight Brother Aviation LLC · Chaffee, NYBuilt 1994 · S/N 4327N476KAN476ka LLC · Wasilla, AKS/N 1953N47HHJkt LLC · Douglas, WYS/N 2667N483RVan Horn Aviation LLC · Tempe, AZBuilt 1969 · S/N 483N48552Brown Helicopter Inc · Pensacola, FLBuilt 2001 · S/N 5275N488BCButte County Sheriffs Office · Oroville, CABuilt 1993 · S/N 5103N48AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45562N48HHVarney Aviation LLC · Bangor, MEBuilt 1982 · S/N 3620N490WMSouth Florida Water Management District · West Palm Beach, FLBuilt 2008 · S/N 4652N49589North Wind Aviation LLC · Chelan, WABuilt 1976 · S/N 1912N49651Withrotor Aviation Inc · Lakeview, ORBuilt 1975 · S/N 1804N49660Provell Chris J · Rio Linda, CABuilt 1975 · S/N 1825N499WMAgricultural Air Services LLC · Jupiter, FLS/N 4376N49TVHawke Aircraft Holdings Inc · Sandpoint, IDS/N 3074N5000GTimberland Helicopters Inc · Ashland, ORBuilt 1978 · S/N 45163N5001KMontana Air Tankers LLC · Three Forks, MTBuilt 1978 · S/N 2408N50046Orlando Aircraft Sales LLC · Orlando, FLBuilt 1978 · S/N 45173N5005NAircoastal Helicopters Inc · Lantana, FLBuilt 1976 · S/N 1931N5007FPatriot Aviation Inc · Greenville, DENon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 45186
Back to AD 81-18-01 R1