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.

N4859GAirgo Inc · Centralia, ILBuilt 1979 · S/N 17273406N4859LDavinci Ventures Inc · Bolingbrook, ILBuilt 1967 · S/N 28-4211N4859TRamirez-Pagan Abelardo · Copperas Cove, TXBuilt 1972 · S/N 28-7205210N485GRegistered aircraftBuilt 1980 · S/N 172RG0306N485JSPlaskett Mark G · King City, CAS/N 23485N485SBLyddon Aero Center Inc · Liberal, KSBuilt 1978 · S/N 17271485N4860AWolff Paul J · Baraboo, WIBuilt 1956 · S/N 22-4019N4860UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842237N4861ARubbert Randy C · Reynolds, NDBuilt 1956 · S/N 22-4020N4861GFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 17273408N4861LPodolinski Frank · Greensburg, PABuilt 1967 · S/N 28-4213N4861VRegistered aircraftBuilt 1980 · S/N 172RG0403N4862LGunter Gordon D · Green River, WYBuilt 1968 · S/N 28-4216N4863ARud Alexandra E · Clara City, MNBuilt 1956 · S/N 22-4022N4863LZimmerman Marlin · Muscoda, WIBuilt 1967 · S/N 28-4217N4864DChiota Aviation LLC · Waco, TXFirst renewal noticeBuilt 1979 · S/N 17272377N4864FFreely James John · Marshall, VAS/N 28-7790069N4864GLazy Eights Holdings LLC · Greenwood, INBuilt 1979 · S/N 17273411N4864LRegistration Pending · Boone, NCRegistration pendingBuilt 1967 · S/N 28-4218N48652Lorenz John C · Edgewood, NMBuilt 1943 · S/N 135N4865DBlack Hound Aviation LLC · Austin, TXS/N 17273904N4867DFlynn Brian · Auburndale, FLBuilt 1979 · S/N 17272378N4867L23 Right LLC · Kalispell, MTBuilt 1967 · S/N 28-4221N4868EVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 17271671N4868LWinningham Matthew P · Prattville, ALBuilt 1968 · S/N 28-5123N4869ANevill Bernard L · Clare, MIBuilt 1956 · S/N 22-4029N486EMMason Edward R Trustee · Wilsonville, ORS/N 001N486FLBaker Donnie · Christiana, TNBuilt 1971 · S/N 28-7125295N486JWWade James M · Calhoun City, MSBuilt 1993 · S/N 1398N486KWilliams Lawrence J II · Tucson, AZBuilt 2005 · S/N 486N486PRichardson Joshua R · Mobile, ALBuilt 1965 · S/N 28-21079N4870DSherman Hess M · Poplar Grove, ILBuilt 1979 · S/N 17272379N4870GCal Aggie Flying Farmers Inc · Davis, CABuilt 1979 · S/N 17273417N4870LWinyah Aviation LLC · Georgetown, SCBuilt 1967 · S/N 28-4225N4870UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842238N4871BMeise Fred Walter · Moses Lake, WAS/N 18-4967N4871CFalvey Paul J · Edgartown, MABuilt 1984 · S/N 28-8490101N4871VBt Aero Precission Flight Accademy LLC · Oakdale, CABuilt 1980 · S/N 172RG0406N4872AIdaho Wool Growers Assn · Boise, IDFirst renewal noticeS/N 18-4969N4872DPs N4872d LLC · Green Bay, WIBuilt 1979 · S/N 17272381N4872LMartin Marvin J · Conrath, WIBuilt 1968 · S/N 28-4227N4873APapp Jacob R · Fort Edward, NYS/N 18-4971N4873FFirebrand Nation · Knoxville, TNS/N 28-7725034N4873G4873g Flying Club Inc · Punxsutawney, PABuilt 1979 · S/N 17273420N4873LBaker Justin · Titusville, FLBuilt 1967 · S/N 28-4229N4875FVan Kirk Ronald · Wichita Falls, TXBuilt 1976 · S/N 28-7725033N4876FCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17273094N4876GKing Bryan A · Austin, TXBuilt 1979 · S/N 17273423N4877DAviator Air Flight School LLC · Grand Prairie, TXBuilt 1979 · S/N 17272383N4877JR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273687
Back to AD 79-10-03 R2