OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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.

N6401UBlue Sky Aviation Adventures LLC · St George, UTS/N 2148N6401VGdl Aviation LLC · Lincoln, NEBuilt 1980 · S/N 172RG0663N64020Bend Aircraft Mechanics LLC · Bend, ORBuilt 1975 · S/N 17264966N64023Rawson Aviation LLC · Collinsville, OKBuilt 1975 · S/N 17264969N6402QMooney Mooney Mooney LLC · Gig Harbor, WABuilt 1967 · S/N 670142N6402UMccleave Thomas · Everett, WABuilt 1962 · S/N 2149N6402VG&M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0664N64034State Of Louisiana · Baton Rouge, LABuilt 1981 · S/N 17275507N64035Loomis Darwin · Mooreland, OKBuilt 1975 · S/N 17264980N6403JDog House Aviation LLC · Houston, TXBuilt 1968 · S/N 28-4819N6403QMiller Fred J · Sahuarita, AZBuilt 1967 · S/N 670143N6403VVista Aviation Inc · Pacoima, CABuilt 1980 · S/N 172RG0665N6403WDanford Scott M · Chickamauga, GAS/N 28-20471N64040Golding Donald J · Tucson, AZBuilt 1981 · S/N 17275509N64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeBuilt 1975 · S/N 17264981N64045Walker Robert · Chula Vista, CABuilt 1975 · S/N 17264983N64046Biesecker Michael Gary · High Point, NCBuilt 1975 · S/N 17264984N64048Gray Peter A · Salinas, CABuilt 1975 · S/N 17264986N6404JMorgan Donelle C · Cambria, CABuilt 1968 · S/N 28-4820N6404UPhiyawa Airplane Holding Inc · Argyle, TXBuilt 1962 · S/N 2151N64053Collins Thomas A · Orleans, MABuilt 1975 · S/N 17264990N64056Angel Aviation Inc · Peoria, AZBuilt 1981 · S/N 17275512N6405JTubesing Gordon Earl Trustee · Palm Coast, FLBuilt 1968 · S/N 28-4821N6405WNightline Air LLC · Saratoga Springs, UTBuilt 1964 · S/N 28-20473N64061Stark Glenn M · Nampa, IDBuilt 1975 · S/N 17264994N64062M G Enterprises Of Albert Lea Inc · Alden, MNBuilt 1975 · S/N 17264995N64063Bowers Alan B · Bellevue, WABuilt 1975 · S/N 17264996N64065Lg Holdings LLC · Gretna, NES/N 17275514N64067Duvall Chris D · Tahlequah, OKBuilt 1975 · S/N 17264998N64069Whiskey Tango Aviation LLC · Keene, NDBuilt 1981 · S/N 17275515N6406JAntonovich Thomas W · Mesa, AZBuilt 1968 · S/N 28-4823N6406QHilten Robert W · Columbus, MTBuilt 1967 · S/N 670146N64074Green Norman D · Lake City, FLBuilt 1975 · S/N 17265000N64079Portneuf Holdings LLC · Chubbuck, IDBuilt 1981 · S/N 17275516N6407DWalo Enterprises LLC · Aurora, COBuilt 1979 · S/N 17272790N6407RKubisiak Steven F · Amherst, WIBuilt 1966 · S/N 28-21586N6407WDoeden Patricia · Hillsborough, NCBuilt 1964 · S/N 28-20476N64081Burrows Donna M Trustee · Grain Valley, MOBuilt 1975 · S/N 17265004N64082Mcdonald Douglas W Sr · Cornelia, GABuilt 1975 · S/N 17265005N64087California Airways LLC · Hayward, CABuilt 1981 · S/N 17275519N6408ASpecialty Aero LLC · Creswell, ORBuilt 2000 · S/N 22079N6408GWebb Joe R · Union, WABuilt 1979 · S/N 17273594N6408JGish David L · Mooresville, NCBuilt 1968 · S/N 28-4825N6408UMckee Michael S · Piney Creek, NCBuilt 1962 · S/N 2155N64092Falcon William D · Elkhorn, WIS/N 17265012N64095Righthand 2004 LLC · Charlotte, NCBuilt 1975 · S/N 17265015N64096Bissey Roy H II Trustee · Big Horn, WYBuilt 1975 · S/N 17265016N6409DMontgomery Aviation LLC · San Diego, CABuilt 1979 · S/N 17272791WPN6409QButz Kyle W · Swanton, OHBuilt 1967 · S/N 670149N6409RFly 365 Ltd · Montrose, COBuilt 1966 · S/N 28-21588
Back to AD 79-10-03 R2