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.

N2376Moore Charles D · Willow, AKBuilt 1992 · S/N 2062N2376JWinstead Jonathan M · Griffin, GABuilt 1963 · S/N M-339N2376LRbg Aviation LLC · Middleburg, FLBuilt 1963 · S/N M-212N2376PBoyd Paul E · North Pole, AKBuilt 1955 · S/N 22-2767N2376QEisenmann James R · Fort Worth, TXBuilt 1963 · S/N M-450N2376TStranberg Ray L · Bakersfield, CAS/N 28-7225057N2377Young Robert L · Oakwood, ILBuilt 1970 · S/N 16408488N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256N2377LBarnes Matthew · Cost, TXS/N M-217N2377UCardinal Flight Systems LLC · Cary, NCBuilt 1979 · S/N 28-8016021N2378Suridutch Inc · Englewood, FLBuilt 1992 · S/N 2066N2378TKeiffer Taylor H · Atlanta, GABuilt 1971 · S/N 28-7225059N2378UInternational Flight Academy LLC · Ft Worth, TXBuilt 1979 · S/N 28-8016022N2378ZMugleston Tim H · Waldport, ORBuilt 1962 · S/N M-102N2379KEast Bay Inc · Stanton, MNBuilt 1979 · S/N 18-8009054N2379YThelwell Llansley · Frisco, TXBuilt 1967 · S/N 17700179N237BMarcum William N · Corpus Christi, TXBuilt 2003 · S/N 60070N237CSHorizon Flyers LLC · Kingsford, MIBuilt 1968 · S/N 28-24230N237HYZeus Flight LLC · Ketchum, IDBuilt 2003 · S/N 2237N237LSSouth Florida Ultralights Inc · Mulberry, FLBuilt 2020 · S/N 21242N237MLN237ml LLC · Glennallen, AKS/N 18-6787N2380Atlantic Rotors LLC · Saint Inigoes, MDBuilt 1992 · S/N 2070N2380MPiggott William H · Madison, CTBuilt 1977 · S/N 28-7890249N2380PWalker Kody Chance · Hobbs, NMBuilt 1955 · S/N 22-2771N2380TRegistered aircraftS/N 28-7225060N23824American Lighthouse Transportation Inc · Dry Ridge, KYBuilt 1977 · S/N M-1999N2382LRadloff Nicholas R · Fort Atkinson, IABuilt 1963 · S/N M-222N2382TGethers Adolph B · Dothan, ALBuilt 1971 · S/N 28-7205031N23830Klosterman Jack L · Cincinnati, OHBuilt 1978 · S/N M-2002N2383PJkr7 LLC · The Dalles, ORBuilt 1955 · S/N 22-2774N2383WMcclure Miles · Vancouver, WAS/N MB-18N2384JEdwards Isaac J · Glen Ellyn, ILBuilt 1963 · S/N M-342N2384PLarsen Steve J · Colton, ORS/N 22-2775N2384QTailwind Ventures LLC · Three Rivers, MIS/N M-464N2384YArea-I Flying Club LLC · Atlanta, GAS/N 17700184N23851Giordano Kim O · Foxboro, MABuilt 1978 · S/N M-2006N23859Fu Jinlin · Olympia, WABuilt 1976 · S/N MB-811N2385TSquawk 1200 LLC · Springboro, OHBuilt 1971 · S/N 28-7225064N2385YSpeedboat Photo Helicopter LLC · Rehoboth Beach, DES/N 0538N2386ENiblack Ward Scott · Tecumseh, MIBuilt 1978 · S/N 17271261N2386MHoeffler James P · Fort Collins, COBuilt 1946 · S/N 12-1628N2386RLand Air & Sea LLC · Concord, NCBuilt 1970 · S/N 28-5602N2386THub City Aviation Academy LLC · Lubbock, TXBuilt 1971 · S/N 28-7225065N2386ZHoffman Kurt T · Savannah, GABuilt 1962 · S/N M-109N2387BMacken Inc Corp · Saint Paul, MNBuilt 1948 · S/N 3687N2387SWittkop Joseph D · Dillingham, AKBuilt 1979 · S/N 18-7909142N2388YMay James E · Nashville, GABuilt 1967 · S/N 17700188N2388ZKoehler Brian L · Washington, IAS/N M-94N2389WCherney Cody L · Belleville, KSBuilt 1966 · S/N MB-24N238ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496037
Back to AD 79-10-03 R2