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.

N530RRVertical Access Helicopters LLC · Clermont, FLS/N 1302N531AGTwo Tails LLC · Las Vegas, NVBuilt 2002 · S/N 4564N533RAEnglish Air Service LLC · Georgetown, TXBuilt 1970 · S/N 533N533TTWestern Farming LLC · Missoula, MTBuilt 1974 · S/N 1517N53702Helicopter Applicators Inc · Gettysburg, PABuilt 1983 · S/N 51249N5373UTimberland Helicopters Inc · Ashland, ORBuilt 1988 · S/N 4011N537TMbm Aviation Consultants Inc · Wilmington, DEBuilt 1980 · S/N 2993N53AEAir Evac Ems Inc · O Fallon, MOS/N 45300N53JWLegacy Endeavors LLC · Bigfork, MTBuilt 1970 · S/N 581N53MAAg Air Inc · Johnstown, COBuilt 1977 · S/N 2285N53QD H Helicopter Inc · Mascoutah, ILS/N 4035N543CCBighorn Flying Co LLC · Wood River, NEBuilt 1982 · S/N 3593N543SAShier Aviation Corporation · San Diego, CAS/N 2674N545SAShier Aviation Corp · San Diego, CABuilt 1983 · S/N 51063N546SACertified Medical Enterprises LLC · Murrieta, CABuilt 1976 · S/N 1939N54AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45157N54NYWisk Aero LLC · Mountain View, CABuilt 1983 · S/N 45770N54SPIndiana State Police · Indianapolis, INS/N 51062N553EAEdgefield Aviation LLC · Sandy, ORBuilt 1966 · S/N 215N555NBHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1977 · S/N 2306N555PPEl Aero Services LLC · Elko, NVBuilt 1988 · S/N 4021N555SJApex59 LLC · Saint Paul, MNBuilt 1968 · S/N 308N555THRegistered aircraftBuilt 1973 · S/N 1173N55UPAlba Leasing Services LLC · Scottsdale, AZBuilt 1983 · S/N 3750N560PK&D Aviation LLC · Kingston, OKBuilt 1982 · S/N 51013N565VALuig 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 3193
Back to AD 89-22-01 R1 L