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.

N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037N397DJRickenbach Andreas N · Truckee, CABuilt 1967 · S/N U206-0881N3992GFlat Earth LLC · Kalispell, MTS/N U2060992N3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCBuilt 1968 · S/N U206-0995N399KMCustodio Olga · San Antonio, TXBuilt 1973 · S/N 21059982N39BEAberdeen Flying Service · Aberdeen, SDBuilt 1984 · S/N 21064889N3KKKraussman Daniel J · San Antonio, TXBuilt 1978 · S/N 21062752N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093N411TTRambod Marc · Taos Ski Valley, NMBuilt 1975 · S/N 21060861N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566N4194QJacques Jerry J · Iliamna, AKS/N U2061359N41ARobertson Roy E · Marion, IABuilt 1978 · S/N 21062798N41CEWhats Up Doc Aviation LLC · Alexander, ARBuilt 1978 · S/N 21062872N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040N422RKGulf Coast Aerial Mapping Co Inc · Gonzales, LABuilt 1979 · S/N U20605347N422SWLarson Daniel · Mora, MNBuilt 1977 · S/N 21062164N424ADSky West Aviation Inc Trustee · Albuquerque, NMS/N 20700337N439DCLaguna Sky LLC · Wilmington, DES/N 21062636N43KYPinto Carlos Eduardo · Tucson, AZBuilt 1972 · S/N 21059563N4414RKirk Ledoux · Stanwood, WABuilt 1979 · S/N U20605111N4429ETwo Niner LLC · Portola Valley, CAS/N 21064709N4429LShingebiss LLC · Independence, ORBuilt 1982 · S/N 21064647N444BSSiemens Christopher L · Seminole, TXBuilt 1978 · S/N 21062823N444FRegistration Pending · Auburn, CARegistration pendingBuilt 1977 · S/N 21061686N444RWBackus Gary Carl · Chesapeake, VABuilt 1979 · S/N 21063465N448AKN448ak LLC · Helena, MTBuilt 1974 · S/N U20602295N448BBHawkflight LLC · Sugar Land, TXBuilt 1979 · S/N 21063563N44ECN44ec LLC · Caddo Mills, TXBuilt 1980 · S/N 21063972N44EEEchemann Thomas A · Sidney, OHBuilt 1979 · S/N 21063723N44HRCardinal Aviation Services LLC · Castle Rock, COBuilt 1978 · S/N 21062685N44NTTucker Nicholas B · La Canada, CABuilt 1981 · S/N 21064531N44WHKelly Sean R · Bozeman, MTS/N 21061316N456BWCustom Wholesale Supply Co Inc · Odessa, TXBuilt 1975 · S/N 20700298N458DJSurvey America Inc · Rancho Cordova, CABuilt 1980 · S/N U20605833N4594CSt Johns Aviation LLC · Saint Johns, MIBuilt 1979 · S/N 21063569N45XDSubstation Air LLC · Midvale, UTBuilt 1981 · S/N 21064495N4600UDlw Aviation LLC · Missoula, MTBuilt 1983 · S/N 21064789N4604QBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 21059504N4607F7 Fox LLC · Eugene, ORBuilt 1966 · S/N P206-0207N4607QSerrano Lynn A · Casa Grande, AZBuilt 1971 · S/N 21059507N4608CTrinity Property Management LLC · Corvallis, ORS/N 21063572N4609UJerden Corp · Overland Park, KSBuilt 1979 · S/N U20605000N460CBScott Ts Ag-Flyin Inc · Colquitt, GABuilt 1966 · S/N P206-0206N4616CSan Angelo Aero L L C · San Angelo, TXS/N 21063576N4620YCenturion Travel LLC · Fort Worth, TXBuilt 1980 · S/N 21063960N4623FHatfield William G · Nunica, MIBuilt 1966 · S/N P206-0223N4627QMassey Larry A · New Braunfels, TXBuilt 1971 · S/N 21059527N4631CGraves Martin · Odessa, TXBuilt 1979 · S/N 21063582N4644UWineglass Holdings LLC · Fort Davis, TXBuilt 1983 · S/N 21064797N4645FScruggs Ken R · Galloway, OHS/N P206-0245
Back to AD 71-09-07 R1