OpenAirDocs.org
AD 71-09-07 R1

Registered aircraft · 1,686

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:71-09-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:71-09-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.

N9870YDejong Arie H · Maricopa, AZFirst renewal noticeBuilt 1981 · S/N 21064621N9876ZGv Air Inc · Medford, ORBuilt 1983 · S/N U20606721N988MVMiller James A · Granada Hills, CABuilt 1967 · S/N T210-0284N9890YValiair Lc Trustee · Casper, WYS/N 21064630N9894YRaymond Andy · Council Bluffs, IABuilt 1981 · S/N 21064632N9909NMorgan Vernon E · Dillon, COS/N 21063250N990VPValenzuela Pedro · Douglas, AZBuilt 1979 · S/N U206-04673N9916ZWings Of Wisconsin LLC · New Richmond, WIS/N U20606744N9922YInfinite Wings LLC · Henderson, NVBuilt 1982 · S/N 21064640N9923YPostupack Peter Jr · New Cumberland, PABuilt 1982 · S/N 21064641N9923ZChena River Aviation Inc · Fairbanks, AKBuilt 1983 · S/N U20606747N9926NBelchak Timothy A · Albuquerque, NMS/N 21063252N9928YEckelkamp L B Jr · Washington, MOBuilt 1982 · S/N 21064643N992PSProctor Gary · Wichita, KSBuilt 1978 · S/N 21063074N9934XLogue James · Fort Worth, TXBuilt 1975 · S/N 21060916N9948ZAlien Invaders LLC · Medina, WABuilt 1983 · S/N U20606767N994CDNavair LLC · Mount Vernon, OHBuilt 1979 · S/N 21063312N994NZFrakes Stephen A · Frisco, COBuilt 1978 · S/N 21062470N9959YGrand Aviation LLC · Winter Park, COFirst renewal noticeBuilt 1982 · S/N 21064648N9960RInternational Air Services Inc Trustee · Carson City, NVS/N U20607001N9962MFox Aircraft LLC · Bethel, AKS/N 20700765N9963YN9963y LLC · Provo, UTBuilt 1982 · S/N 21064649N9964YGreenspun Mark H · Washington, DCBuilt 1982 · S/N 21064650N9968NBuhannic Patrick A · Shepherdstown, WVS/N 21063259N9976MBrush Wesley A · Sparks, NVBuilt 1978 · S/N U20604626N997RRegistered aircraftBuilt 1974 · S/N 21060386N9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1982 · S/N 21064659N9983MTate Clint · Boise, IDBuilt 1978 · S/N U20604632N9986MLogan Timothy R · Valley City, NDS/N U20604635N9991YArwlb Aviation LLC · Spokane, WABuilt 1982 · S/N 210-64661N9992NHanson Lavon T · Saint Ignatius, MTS/N U20603749N999PCFlying T LLC · Albuquerque, NMBuilt 1972 · S/N 21059694N99QTNielsen4 LLC · Seattle, WABuilt 1968 · S/N U206-1017N99YZEdwal Aviation LLC · Reno, NVBuilt 1981 · S/N 21064608N9EDTaylor Monty · Cornelius, NCBuilt 1972 · S/N 21059612N9TRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N 21059846
Back to AD 71-09-07 R1