AD 2001-22-01

Registered aircraft · 276

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

N43MHKorb Thomas M · Owasso, OKBuilt 1978 · S/N 1148N44XAMackechnie Martin J · Palm Harbor, FLS/N 771N454PCannon Travis H II · Corinth, TXBuilt 2013 · S/N 2136N46MUMedic Choppers LLC · Springdale, ARS/N 253N4874Goin Jeff Trustee · Polk City, FLBuilt 1968 · S/N 025N4878Medic Choppers LLC · Springdale, ARBuilt 1969 · S/N 029N4889Albert Lea Arpt Inc · Albert Lea, MNBuilt 1969 · S/N 041N494HSale Reported · West Palm Beach, FLSale reported, pending cancellationBuilt 1975 · S/N 309N501EHDupont Pierre B · Menominee, MIBuilt 1966 · S/N 5N503PDWjt Investments LLC · Gurley, ALS/N 813N50AZBenson Aviation LLC · Mehoopany, PAS/N 2093N50DRAdf Helicopters Inc · Brewster, WAS/N 1203N51659Hawk Robert S · Argyle, TXBuilt 1977 · S/N 1098N51665Rotor-Lift LLC · Swartz Creek, MIS/N 404N51693Borreson Anthony · Reno, NVBuilt 1977 · S/N 411N51699Styer David B · Pendleton, ORBuilt 1977 · S/N 416N516BYIberlin James M · Gillette, WYBuilt 1992 · S/N 788N51723Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 1136N51735Styer David B · Milton Freewater, ORBuilt 1978 · S/N 1139N51739Quality Aero LLC · East Aurora, NYS/N 1141N51757Spencer John S · Indian, AKBuilt 1978 · S/N 423N51758Enstrom Instruction LLC · Newark, DEBuilt 1978 · S/N 435N51768Stocker Concrete Co · Gnadenhutten, OHBuilt 1978 · S/N 446N51769Arizona Skies Aviation LLC · Scottsdale, AZS/N 443N51770Lrh Equipment LLC · Pendleton, ORS/N 445N51774Salaika Timothy A · Danbury, TXS/N 440N51778Medical Evacuation Disaster Intervention Corps · Springdale, ARS/N 451-2N51787Holder Michael T · Whitesburg, GABuilt 1980 · S/N 1172N51788Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 452-2N51789Breyer Charles A · Lewes, DEBuilt 1978 · S/N 454-2N518EGStyer David B · Pendleton, ORS/N 812N519HCain James W · Big Rapids, MIBuilt 1975 · S/N 322N51PDBcww LLC · Bakersfield, CABuilt 1996 · S/N 806N520HKirsch Kenneth L · Carneys Point, NJBuilt 1975 · S/N 325N529HJsh Farms Inc · Hermiston, ORBuilt 1976 · S/N 1042N52PDAviation Endeavors LLC · Houston, TXBuilt 1996 · S/N 807N539HSharkey'S Helicopters Inc · West Lebanon, NHBuilt 1976 · S/N 334N53PCMckenney Bret K · Billings, MTS/N 2028N53SABorreson Anthony · Reno, NVBuilt 1977 · S/N 385N542HGraham Jack D · Hamilton, TXBuilt 1976 · S/N 343N544HLrh Equipment LLC · Pendleton, ORS/N 335N549HBazemore Dennis A · Ingleside, TXBuilt 1976 · S/N 345N554HSouthworth Elizabeth A · Igo, CABuilt 1976 · S/N 1039N565XMackechnie Martin J · Palm Harbor, FLBuilt 1978 · S/N 1138N56874Styer David B · Pendleton, ORBuilt 1979 · S/N 467N5687PBrown Clifford J · Hoschton, GAS/N 1167N5688RLowell Darryl S · Anchorage, AKS/N 466-2N5688TJoe Koch Construction Inc · Youngstown, OHBuilt 1980 · S/N 480-2N5689NRobinson Ryan A · Burbank, CABuilt 1979 · S/N 468-2N5690BK & L Aerial LLC · Echo, ORBuilt 1979 · S/N 1171
Back to AD 2001-22-01