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.

N5086ANeeley James L · Temecula, CAS/N 21063263N5089C5089c LLC · Fairhope, ALBuilt 1979 · S/N 21063701N508TCFisher Travis L · Odessa, TXBuilt 1982 · S/N 21064741N50901United Indian Missions Inc DBA · Tucson, AZBuilt 1973 · S/N U20601951N50CTAyers Jeffrey D · Canandaigua, NYBuilt 1978 · S/N 21062937N5105YMcduff Douglas M · Cook, MNBuilt 1980 · S/N 21064074N5106CQuest Aviation Inc · Lake City, FLBuilt 1979 · S/N 21063704N5107CDalrymple Michael J · San Luis Obispo, CABuilt 1979 · S/N 21063705N5109QRmcb LLC · Kalispell, MTBuilt 1972 · S/N 21059609N510WFFuel Center Plus Inc · Silver City, NMBuilt 1980 · S/N 21064140N5114QJ&A Air · Richfield, UTS/N 21059614N5119XMission Aviation Fellowship · Nampa, IDBuilt 1980 · S/N U20605571N5119YWby Aviation LLC · Lewes, DES/N 21064083N511DCJago River Holdings LLC · Fairbanks, AKBuilt 1966 · S/N U206-0543N511RLHatch Leasing Co LLC · Marble Canyon, AZBuilt 1973 · S/N U20602109N5122QPyxis LLC · Cheyenne, WYBuilt 1972 · S/N 21059622N51237Infanger James Robert · Salmon, IDS/N U20601983N5127QRegistered aircraftBuilt 1972 · S/N 21059627N512GTBarron Thomas Aviation Inc · Scottsdale, AZBuilt 1974 · S/N 21060178N512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1978 · S/N 21063034N5130AAll Florida Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 21063280N5130YMerritt LLC · Leesburg, VABuilt 1980 · S/N 21064087N5131QLeavitt Craig S · Spicewood, TXBuilt 1972 · S/N 21059631N5141QImagination Publications Inc DBA · Saratoga, WYBuilt 1972 · S/N 21059641N5144UAeronaut LLC · Saint George, UTBuilt 1984 · S/N 21064851N5151QNotsa LLC · Morrison, COBuilt 1972 · S/N 21059651N5154AA&J Air Sales Inc · San Antonio, TXS/N 21063289N5156QN5156q Inc · Elmhurst, ILFirst renewal noticeBuilt 1972 · S/N 21059656N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292N515RTCemco Industrial Park LLC · Belen, NMBuilt 1976 · S/N 21061235N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114N5191VTrue Drilling LLC · Casper, WYBuilt 1975 · S/N 21060857N5195AOlson Brothers · Williams, AZBuilt 1979 · S/N 21063304N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602N51SARedtail Partners LLC · Moab, UTBuilt 1981 · S/N 20700699N5201ADan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1979 · S/N 21063305N5203AGv Air Inc · Medford, ORBuilt 1979 · S/N 21063306N5203XMike & Critter LLC · Mccall, IDBuilt 1980 · S/N U20605592N5217CHydro Wings Inc · Valle Crucis, NCBuilt 1979 · S/N 21063719N5223AGeneral Plumbing Inc · Walnut Creek, CABuilt 1979 · S/N 21063316N5225VKuhn Chad · Boulder, WYBuilt 1975 · S/N 21060867N5228VDynamite Marketing Inc · Meridian, IDBuilt 1975 · S/N 21060870N522GHQuailridge Aviation LLC · Clarkston, WABuilt 1979 · S/N 21063399N523RCS W Air Travel Inc · Parshall, COBuilt 1975 · S/N 21060654N5244ZRobinson Levi B · Anchorage, AKBuilt 1981 · S/N U20606085N524MMAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 21063717N5252ALong Harold M · Carson City, NVBuilt 1979 · S/N 21063327
Back to AD 71-09-07 R1