OpenAirDocs.org
AD 97-21-07 R1

Registered aircraft · 164

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:97-21-07-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:97-21-07-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.

N233LEArmy Aviation Heritage Foundation And Museum Inc · Hampton, GABuilt 1979 · S/N 79-23233N234SJPorter Flying Services Inc · Chico, CABuilt 1962 · S/N 388N256KTKord Technologies Inc · Huntsville, ALS/N 69-15075N262RCUS Airlift Command Inc · Anderson, SCBuilt 1971 · S/N 70-16443N264RMRocky Mountain Construction LLC · Klamath Falls, ORBuilt 2012 · S/N 70-16424N2650NIaba LLC · Norfolk, VAS/N 2002N267KATimberline Helicopters Inc · Sandpoint, IDBuilt 2003 · S/N A94-0037N2773HSummit Helicopters Inc · Salem, VABuilt 1979 · S/N 30296N283HFArmy Aviation Heritage Foundation And Museum Inc · Hampton, GABuilt 1966 · S/N 66-15283N284MMMarble Mountain Helicopters LLC · Roseburg, ORBuilt 1964 · S/N 6413813N28HXHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 30034N30111Sky Walker Aviation LLC · Indianapolis, INBuilt 1968 · S/N 68-16563N304HALyons Aircraft Leasing LLC · Hillsboro, ORBuilt 1972 · S/N 30110N3053QWest Valley Aviation Inc · Five Points, CABuilt 1966 · S/N 66-1104N313BNorthwest Helicopters Inc · Olympia, WABuilt 1963 · S/N 63-08765N314Central Copters Inc · Bozeman, MTBuilt 2001 · S/N A94-0032N319WASky High Leasing LLC · Montrose, COBuilt 2019 · S/N A94-0048N324MWMountain West Helicopters Of Montana LLC · Missoula, MTBuilt 1965 · S/N 65-09856N3276KMooney Seven Inc · San Antonio, TXBuilt 1967 · S/N 67-19521N333XLCj Air LLC · Nezperce, IDBuilt 1967 · S/N 154951N334WNPope Jim D DBA · Lewiston, IDBuilt 1962 · S/N 62-2097N33HXCopter Lease LLC Trustee · Albuquerque, NMBuilt 1976 · S/N 30235N353RCN353rc LLC · Chelan, WAS/N 6600782N357KAHeli 807 Leasing LLC · Anchorage, AKBuilt 2001 · S/N A94-0028N3605Mann Peter D · Willows, CABuilt 1944 · S/N 568N374PACopter Lease LLC Trustee · Albuquerque, NMBuilt 1979 · S/N 30931N3803CState Of Colorado Department Of Public Safety · Lakewood, COBuilt 1968 · S/N 30006N3804CState Of Colorado Department Of Public Safety · Lakewood, COBuilt 1980 · S/N 30314N39HXHelicopter Express LLC · Chamblee, GABuilt 2017 · S/N A94-0042N3XLNixon Helicopters LLC · Mentone, CABuilt 1977 · S/N 77-22758N4040PR & R Conner Aviation LLC · Conner, MTBuilt 1965 · S/N 65-7911N406JPHeli-Works Flight Services LLC · Deer Lodge, MTBuilt 1969 · S/N 69-15855N40722West Valley Aviation Inc · Five Points, CABuilt 1969 · S/N 69-15256N40HXHelicopter Express LLC · Chamblee, GABuilt 2019 · S/N A94-0051N41109Lrh Equipment LLC · Pendleton, ORS/N 11968N421NCState Of North Carolina · Raleigh, NCBuilt 1964 · S/N 64-13544N430BHBering Air Inc · Nome, AKBuilt 1965 · S/N 65-09702N4376DPlanes Of Fame Air Museum · Chino, CAS/N 61-2692N43FKKaman Aerospace Corp · Bloomfield, CTBuilt 1962 · S/N 60-0289N43HXHelicopter Express LLC · Chamblee, GABuilt 2001 · S/N A94-0029N444SJJones Flying Service · Biggs, CABuilt 1962 · S/N 391N449RCCounty Of San Diego · El Cajon, CABuilt 1973 · S/N 30121N453CCHelo 1 LLC · Anchorage, AKBuilt 1968 · S/N 155352N474THTop Hand Inc · Laurel, MTBuilt 1968 · S/N 68-15474N5073XMartins Dusters Inc · Colusa, CABuilt 1963 · S/N 63-8622N515Savauge Air LLC · North Las Vegas, NVBuilt 1975 · S/N 30759N51AFEastern Stearman Inc Trustee · Leesburg, VAS/N 5082N526MWMountain West Helicopters LLC · Saratoga Springs, UTBuilt 1994 · S/N 0004N530NCCopter Lease LLC Trustee · Albuquerque, NMBuilt 1972 · S/N 30544N534HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1973 · S/N 30142
Back to AD 97-21-07 R1