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.

N1935LBlais Aviation Services LLC · Frisco, TXBuilt 1976 · S/N MB-797N1935TWebboe Investments LLC · Falls Church, VABuilt 1971 · S/N 287105153N1936AHead Joseph A · Fairbanks, AKBuilt 1952 · S/N 18-1770N1936FCheek David H · Garland, TXBuilt 1979 · S/N 17273026N1936GDowning John T · Tucker, GABuilt 1936 · S/N 6N1936HBarts Flying Service · Storm Lake, IABuilt 1977 · S/N 28-7716066N1936LAnderson Brian E · Edmond, OKBuilt 1976 · S/N M-1846N1936SMoore Christopher D · Cheyenne, OKBuilt 1964 · S/N 28-3173N1936TN1936t LLC · Franklin Park, NJBuilt 1971 · S/N 28-7105154N1936WDelgatto Robert G · Bellingham, WAS/N MB-599N1937FA2 Flight Leasing LLC · Castro Valley, CABuilt 1979 · S/N 17273027N1937GGriffin Gerald D · Hunt, TXBuilt 1959 · S/N 18-7124N1937HTerra Alfred Jr · Taunton, MABuilt 1977 · S/N 28-7790358N1937PPro West Air LLC · West Point, UTS/N 22-2688N1937TChristianson Eric L · Peoria, AZBuilt 1971 · S/N 28-7125490N1937WMcculloch Jordan · Enfield, CTBuilt 1973 · S/N MB-600N1938ABullock Brian R · Cambridge Springs, PABuilt 1952 · S/N 18-1772N1939GMorgan Larry D · Blair, NEBuilt 1989 · S/N 2890107N1939RAmos Russ · Batesville, ARBuilt 1980 · S/N 00TMN193ACStearman Aviation Inc · Crawford, COBuilt 1993 · S/N 365-93N193CPStillwater Aviation LLC · Winter Haven, FLBuilt 1977 · S/N 18-7709063N193DMOrtega Melissa Jean · Oxford, PABuilt 1995 · S/N 1093N193DRLinden Elizabeth M · Mc Farland, WIS/N 193N193GCTnt Machining Company LLC · Russell, KYBuilt 1990 · S/N 1549N193JSRyan Moore LLC · Fayetteville, NCBuilt 1975 · S/N 17265118N193JTMaroon Aviation LLC · Ferriday, LAS/N 1233N193SPIndiana State Police · Greenwood, INS/N 172-76346N193WMCarter Jason W · Owens Cross Roads, ALBuilt 1970 · S/N 28-5795N1940FAmerican Asset Leasing LLC · Livermore, CAS/N 17273030N1940LClark Sean William · Shelby, NCBuilt 1976 · S/N M-1808N1940PBrown Gerald M · Menan, IDBuilt 1955 · S/N 22-2691N19419Dean Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 17702570N1941VSale Reported · Bloomburg, TXSale reported, canceledBuilt 1984 · S/N 28-8490056N1942TGullion Monte C · Scottsburg, INBuilt 1971 · S/N 28-7105155N1942ZThird Step 5 LLC · Gilbert, AZS/N 28-22849N1943KRanta Kenneth J · Excelsior Springs, MOS/N 2514N1943LBeech Shuttle LLC · Dawson, GABuilt 1976 · S/N M-1830N1943TFuhrman Ronald A · Fargo, NDBuilt 1971 · S/N 28-7105156N19445Scott Beau · Ashville, OHBuilt 1976 · S/N 17702572N1944TBeen Flying LLC · Colchester, CTBuilt 1971 · S/N 28-7125497N1945FLake Elmo Aero LLC · Lake Elmo, MNBuilt 1979 · S/N 17273035N1945LN1945l LLC · Cincinnati, OHBuilt 1976 · S/N M-1821N1945PScotia Aero LLC · Fort Myers, FLS/N 22-2696N1945TPatterson John W · Stockton, CABuilt 1971 · S/N 28-7125506N1945WHunhoff Mark B · Yankton, SDBuilt 1973 · S/N MB-603N1946HMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7716067N1947Solomon Isaac H · Baraboo, WIBuilt 1992 · S/N 001N1947FMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273037N1947HHickman Gary Wayne · Alpine, CABuilt 1947 · S/N 185N1947PSpence Ronald J · Germantown, TNBuilt 1955 · S/N 22-2698
Back to AD 79-10-03 R2