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.

N8632ZTate Roger · Redlands, CAS/N P206-0432N8647QTechnical Applications & Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603463N8674ZHoch Lance M · Weiser, IDBuilt 1968 · S/N P206-0474N86DHHolloway'S Tire And Auto Service Inc · Thomaston, GABuilt 1984 · S/N 21064832N8706ZElliott Michael L · Raeford, NCBuilt 1968 · S/N P206-0506N8719ZFedane Rohit · Green Bay, WIBuilt 1968 · S/N P206-0519N8725QN8725q LLC · Grand Junction, COBuilt 1976 · S/N U20603478N8756QTriple 2 LLC · Burlington, COBuilt 1976 · S/N U20603509N8758QBerge Christian · Mccall, IDBuilt 1976 · S/N U20603511N876R76r Holdings LLC · Rockport, TXBuilt 1978 · S/N 21062844N8775ZB&B Auto Body LLC · Terreton, IDS/N P206-0575N8781ZHogue Marc · Tempe, AZBuilt 1969 · S/N P206-0581N8794ZJones Petroleum Co Inc · Jackson, GAS/N P206-0594N8823HBowers Phillip P · Clayton, NCBuilt 1970 · S/N 21059314N886KHLexi Air LLC · Boise, IDBuilt 1977 · S/N 21061727N887WQuad City Area Flying Eagles Inc · Milan, ILBuilt 1975 · S/N 21060976N888ABRegistered aircraftS/N 21062804N888EAAustin E H Jr · San Antonio, TXBuilt 1976 · S/N U20603286N888KAQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 21061046N888KBAarons Plumbing LLC · Grand Ledge, MIBuilt 1973 · S/N 21059894N888PJPatterson Edward · Midland, TXBuilt 1981 · S/N 21064244N888QTake Flyte LLC · Atascadero, CAS/N 21062855N888SALyman Joseph Scott · Kimberly, IDBuilt 1978 · S/N 21062542N8898QNorthrop Grumman Systems Corp · El Segundo, CABuilt 1976 · S/N U20603561N898BHPompa Oliver · Tuscon, AZBuilt 1980 · S/N 21064108N899MDLarson Aeromedical Services LLC · Salem, ORS/N 21059984N899RCOsprey Aviation LLC · Hamilton, MTBuilt 1978 · S/N U20604808N89EPBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 21060380N89KPRegistered aircraftBuilt 1979 · S/N 21063501N8CCMag 3 Aviation LLC · Vidor, TXBuilt 1981 · S/N 21064437N8KMWolding Jeffrey D · Ashland, WIBuilt 1974 · S/N 21060260N8MNNichols Farms · Seminole, TXS/N 21060387N8MXMoncrief Rick L · Melba, IDS/N 21062687N8NURbc Aviation LLC · Hollywood, FLBuilt 1966 · S/N T210-0220N90193Renfro Michael W · Bethel, AKBuilt 1969 · S/N 20700007N9026MGlenn Stephen B · Texarkana, TXBuilt 1977 · S/N 21062051N9046FCenturion Aviation LLC · Lewes, DEBuilt 1979 · S/N 210-63014N9079HJoey Os LLC · Darlington, PABuilt 1979 · S/N 21063829N907JMWright Flight Inc · Tucson, AZS/N 21063665N90MJBlack Alan · Mariposa, CAS/N 21063458N90RWWallace Richard · Santa Teresa, NMBuilt 1979 · S/N 21063283N91016Gosselin Edward M Trustee · Bridgewater, NJBuilt 1969 · S/N 20700011N91025Arctic Aviation Leasing LLC · Anchorage, AKBuilt 1969 · S/N 20700016N91060Second Wind Aviation Corp · Friday Harbor, WAS/N 20700047N91183Hatch Hyrum G · Gilbert, AZBuilt 1969 · S/N 20700106N911EWeiss Elliott · Fresno, TXS/N 20700747N9125YKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N U20603324N916WCBarr Air Patrol LLC · Mesquite, TXBuilt 1980 · S/N U20605677N917WCBarr Air Patrol LLC · Mesquite, TXBuilt 1973 · S/N U20602032N9186TEpi Technologies Inc · Antioch, ILBuilt 1977 · S/N 21062227
Back to AD 71-09-07 R1