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.

N4835FHernandez Christopher A · Phoenix, AZS/N U206-0535N483DMN483dm LLC · Hummelstown, PABuilt 1975 · S/N 21060819N4845CBloss Albert P · Seattle, WABuilt 1979 · S/N 21063642N484KWNunez-Fontes Fernando · Rio Rico, AZBuilt 1980 · S/N 21064066N4853CIdaho Flying Service LLC · Kamiah, IDS/N U20603851N4857CGate Holdings LLC · Ketchum, IDBuilt 1979 · S/N 21063647N4876YCarson Engineering And Manufacturing Inc · Springdale, ARBuilt 1980 · S/N 21064025N4878Y182b LLC · La Plata, NMBuilt 1980 · S/N 21064026N4881U270 W Pearl LLC · Jackson, WYS/N U20605139N4885XEggleston Kevin M · Moore, OKS/N 21060885N4887ZJav Air Services LLC · Anchorage, AKBuilt 1980 · S/N U20606042N4888CGoflight Inc · Birmingham, MIBuilt 1979 · S/N 21063656N4888FTaktos Ltd · Corvallis, ORBuilt 1966 · S/N U206-0588N488RHI F Rooks & Associates LLC · Memphis, TNBuilt 1982 · S/N U20606488N4895YKeating George W · Fayetteville, ARBuilt 1980 · S/N 21064033N4898CPalo Aerocraft Inc · Salem, VABuilt 1979 · S/N 21063659N48ALHutchinson Scott · Missouri City, TXBuilt 1976 · S/N 21061658N48CFRaven Girl LLC · Eagle River, AKS/N 20700366N48VAGeiser Corbin · Little Elm, TXBuilt 1977 · S/N 21061798N4905CAnacapa Capital LLC · Fresno, CABuilt 1979 · S/N 21063664N4909YFremont Airways LLC · Riverton, WYBuilt 1980 · S/N 21064039N4918UMission Aviation Fellowship · Nampa, IDBuilt 1979 · S/N U20605160N491ACEw Pegasus LLC · Walnut Creek, CAS/N 21063673N4922YHowey Aviation LLC · Woodhaven, MIBuilt 1980 · S/N 21064047N4923UUnited Indian Missions Inc DBA · Tucson, AZS/N U20605164N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174N4951FAerial Services Inc · Cedar Falls, IAS/N U206-0651N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689N4964FTeam Builders Inc · Carson City, NVBuilt 1966 · S/N U206-0664N4967FMile Hi Skydivers Inc · Longmont, COBuilt 1966 · S/N U206-0667N4978UKempf Rodney G · Eugene, ORBuilt 1979 · S/N U20605180N4978YBohannon Donald S · Moreland, GAS/N 21064063N4981CWatson Michael · Dalhart, TXS/N 21063699N498TBAdventure Alaska Tours Inc · Hope, AKS/N 21062782N4991FChouinard Christopher P · Friday Harbor, WABuilt 1966 · S/N U206-0691N499KCopper River Airmotive LLC · Copper Center, AKBuilt 1980 · S/N 20700632N49STHedeen Arnold R · Seattle, WAS/N 21064844N4AHHand Kevin D · Anchorage, AKBuilt 1982 · S/N U20606655N4CGAffordable Avionics Ind DBA · Chino, CABuilt 1965 · S/N T210-0033N4LFMacys Flying Service Inc · Tulelake, CABuilt 1977 · S/N U20603705N4VWPronk Glen R · Crittenden, KYBuilt 1974 · S/N 21060277N4YYWilliams Scott Griffin · Salt Lake City, UTBuilt 1979 · S/N 21063553N501SFNomarco Inc · Woodburn, ORS/N 21061808N5026VPiland Kenneth Eldon Jr · Carlsbad, CABuilt 1975 · S/N 21060822N503ATRegistered aircraftBuilt 1975 · S/N 21060924N504JWPalmer Gary H · San Juan, TXBuilt 1981 · S/N 21064232N505SWBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 21061185
Back to AD 71-09-07 R1