OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534N1815JDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N 28-24244N1816TGq Aviation LLC · Cherry Hill, NJBuilt 1971 · S/N 28-7125173N1816ZWestern Anesthesia Assn · Richland, WABuilt 1981 · S/N M-232N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535N1817JCarey Thomas W Jr · Springfield, ILBuilt 1968 · S/N 28-24247N1817TR J Services LLC · Centerton, ARBuilt 1971 · S/N 28-7105142N18184Lerille Red · Lafayette, LABuilt 1941 · S/N A-810N18186Davies Samuel R · Port Angeles, WAS/N A-812N1818JDavey Aaron A · Topeka, KSBuilt 1968 · S/N 28-24248N1818TCopp Gary P · Carson City, MIBuilt 1971 · S/N 28-7105143N1819Peters Sean T · Oak Harbor, OHBuilt 1959 · S/N 22-6705N1819BDudinsky Todd M · Eagle River, AKS/N 20008CN181BAClough James Erwin · Pittsboro, NCBuilt 1981 · S/N 28-8116230N181BHAeronation Aircraft & Exotics LLC · Lewes, DEBuilt 1982 · S/N 28-8390003N181CCrume Christopher C · Englewood, FLBuilt 1960 · S/N TD-440N181DJNew England Aviation LLC · Plainville, CTBuilt 1977 · S/N 28-7790415N181FBaker Myron C · Morrow, OHRegistration revokedBuilt 1959 · S/N 226705N181FATriangle Aviators LLC · Cary, NCBuilt 1983 · S/N 288390062N181GBBartel Gary W · Tucson, AZBuilt 1979 · S/N 28-7990275N181GPPilots Flying School LLC · Manalapan, NJBuilt 1984 · S/N 28-8490061N181HEOzziac Enterprises Inc · Huron, OHBuilt 1988 · S/N 2890078N181LEast Atlantic LLC · Helena, MTS/N 20001CN181MHHurd Mark A · Bono, ARBuilt 1979 · S/N 28-7990279N181PDAnderson Christopher · Wilmington, NCBuilt 1978 · S/N 28-7890462N181PGSkybound Aviation LLC · Kernersville, NCBuilt 1977 · S/N 28-7790584N181REJacobsen Gary J · Yelm, WABuilt 1996 · S/N 195N181RJUaa International Inc · La Verne, CABuilt 1980 · S/N 28-8190106N181TBVector Aviation LLC · Mentor, OHBuilt 1978 · S/N 28-7990212N181TCDezendorf Thomas C · Petaluma, CABuilt 1979 · S/N 28-7990324N181TKAnderson Brad A · Rochester, MNBuilt 1977 · S/N 28-7890193N181TMEichhorn Scott William · Searcy, ARS/N 114-74N181TSJls Aviation LLC · Sarasota, FLBuilt 1975 · S/N 28-7690062N181WFNorton Thomas W · Dayton, NVBuilt 1977 · S/N 28-7890116N181WGFlycasual LLC · Bloomington, ILBuilt 1984 · S/N 28-8490069N181WMWozniak David D · Greenfield, MABuilt 1973 · S/N 28-7405060N181YTailwinds Aviation Academy LLC · Grass Valley, CAS/N 28-8590089N1820H5c1 Jet Center LLC · Boerne, TXS/N 28-7716053N1820VAsp Kenneth · Thief River Falls, MNBuilt 1974 · S/N 17263762N1821BBonney Andrew · Marion, MAFirst renewal noticeBuilt 1976 · S/N M-1907N18226Filler Joseph J · Wyoming, PABuilt 1976 · S/N 17702537N1822GWhr Sales LLC · Riviera Beach, FLFirst renewal noticeBuilt 1968 · S/N 187N1822HAdvanced Aviation Group LLC · Frederick, MDBuilt 1977 · S/N 28-7790345N1822JWright Debra A · Avondale, PABuilt 1968 · S/N 28-24253N1823JFroman Michael J · Mayer, MNBuilt 1968 · S/N 28-24254N1823KCooper Stephen · Fairbanks, AKS/N 4550N1823PGranger Joshua M · Rosebud, MTS/N 22-2603N1823TShowalter Joshua J · Dougherty, IABuilt 1971 · S/N 28-7125206N1824HAthar Glenola LLC · Mars, PABuilt 1977 · S/N 28-7790346N1825JAction Interests Inc · Southlake, TXBuilt 1976 · S/N 13015
Back to AD 79-10-03 R2