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.

N555SJApex59 LLC · Saint Paul, MNBuilt 1968 · S/N 308N555THRegistered aircraftBuilt 1973 · S/N 1173N55UPAlba Leasing Services LLC · Scottsdale, AZBuilt 1983 · S/N 3750N565VALuig Perry J · Holliday, TXS/N 3107N566AFRickards Aviation Group LLC · Dagsboro, DEBuilt 1981 · S/N 45565N56ALBoard Of County Commissioners · Bartow, FLBuilt 1974 · S/N 1402N56BHPinnacle Helicopters Inc · Victoria, MNBuilt 1973 · S/N 1018N56BLHelicopters Inc · Cahokia, ILBuilt 1982 · S/N 3502N570JHHarnden Aviation Group LLC · Harrisburg, PABuilt 1980 · S/N 45428N570LEHhl LLC · Denver, COS/N 45570N570RLJasons Helicopter Services · New Prague, MNBuilt 1980 · S/N 45517N57165Brown Helicopter Inc · Pensacola, FLS/N 3816N571CJRotorpro LLC · Sevierville, TNBuilt 1983 · S/N 45781N5733KEcolift Corp · San Juan, PRS/N 2951N5739VHb7 LLC · Sheridan, WYBuilt 1980 · S/N 3025N573CAChem-Air LLC · Shreveport, LABuilt 1975 · S/N 1785N5743HAspen Ag Helicopters Inc · Oxnard, CABuilt 1980 · S/N 3042N5743WFly Hangar 13 LLC · Mico, TXBuilt 1980 · S/N 3050N5743ZTate James D · St Croix, VIS/N 3051N57441Jbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45438N5745YMonarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45531N5747WFly Hangar 13 LLC · Mico, TXBuilt 1979 · S/N 2812N5747XBlair Air Service Inc · Lemoore, CABuilt 1980 · S/N 3046N57491Monarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45505N5750TScotts Helicopter Service · Le Sueur, MNBuilt 1980 · S/N 3095N5751MTrinkle Aviation LLC · Kingburg, CABuilt 1980 · S/N 45522N576KANorthwest Helicopters I Inc · Olympia, WABuilt 1976 · S/N 1971N579SD2010 Leasing Group LLC · Torrance, CABuilt 1980 · S/N 3193N57EFCk Helicopters LLC · Jasper, INBuilt 1971 · S/N 660N57KKPath Clear LLC · Wilmington, DES/N 4047N57ZT&T Transportation Inc · Lafayette, INBuilt 1980 · S/N 3016N58003San Juan Aviation LLC · Wilmington, DEBuilt 1983 · S/N 1020N58140San Juan Aviation LLC · Wilmington, DEBuilt 1973 · S/N 1108N581SCShelby County Sheriffs Office · Columbiana, ALBuilt 1995 · S/N 5201N582RAMarks Assets Group LLC · Lafayette, LABuilt 1979 · S/N 3582N5869YMid South Aviation Institute · Black Rock, ARBuilt 1971 · S/N 44001N586SCInterstate Helicopters Inc · Bethany, OKBuilt 1976 · S/N 2033N58765State Of Montana · Helena, MTBuilt 2001 · S/N 5276N588TWWillfish LLC · Mentor, OHBuilt 2005 · S/N 4590N58MIndustrial Power Services Corp · Ware, MABuilt 1974 · S/N 1310N59383N57aw LLC · Glendale, AZBuilt 1973 · S/N 1150N59427Ambrosini Helicopters Inc · Fresno, CAS/N 1132N59479Summit Helicopters Inc · Salem, VABuilt 1973 · S/N 1194N59495Knutson Flying Service Inc · Tioga, NDBuilt 1954 · S/N 1373N59548Hendrickson Flying Service Inc · Rochelle, ILBuilt 1974 · S/N 1386N59553Sycan Corp · Paso Robles, CABuilt 1974 · S/N 1451N59564Sale Reported · Topeka, KSSale reportedBuilt 1974 · S/N 1389N59578Ag-Air Inc · Oakdale, CAS/N 1475N59579American Ag Aviation Inc · Five Points, CABuilt 1968 · S/N 1480N595AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45244
Back to AD 81-18-01 R1