OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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-14-R1')
    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-14-R1')
  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.

N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195N2232GBigler Mark · Topeka, KSS/N 51532N22335Johnson Marissa N · Avon, INBuilt 1968 · S/N 15068222N2233DMerrill Christopher D · Albany Twp, MES/N 20385N2233GA F Flyers LLC · American Falls, IDBuilt 1958 · S/N 51533N2233JPalmer Kim W · Lockport, NYBuilt 1966 · S/N 15065433N2233MPutnam John P · Weirsdale, FLS/N 18280069N2233RDorman William James Trustee · Anchorage, AKBuilt 1975 · S/N 18502859N2233SRichardson Robert O · Spring Grove, ILBuilt 1976 · S/N 21061178N2233TSeward Air Taxi LLC · Seward, AKS/N 185-1386N2234GBaldwin Trevor K · Owasso, OKBuilt 1958 · S/N 51534N2234RJones Lennis William III · Rule, TXBuilt 1968 · S/N T210-0384N22351Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 15068229N22354Franks Cory · Idalou, TXS/N 15068232N22355Quinones Steven · Forney, TXBuilt 1968 · S/N 15068233N2235DHasner Mark A · Fairbanks, AKS/N 20387N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198N2235JKnutson Wayne R · Thompson, NDS/N 150-65435N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180N2235VE & R Aviation Services Inc · Long Beach, CABuilt 2007 · S/N 172S10478N22360Levy Peter F · Augusta, KSBuilt 1968 · S/N 15068236N22361Youngblood Steve R · Young Harris, GABuilt 1968 · S/N 15068237N2236RSouthern Skies Aviation Inc · Cedar City, UTS/N T210-0386N2236TParks Walter G · Chugiak, AKBuilt 1968 · S/N 185-1390N22373Roche Timothy P · Falls Church, VABuilt 2007 · S/N 18281928N2237GSmith Caleb · Beggs, OKBuilt 1958 · S/N 51537N2237JSudduth Mark E · Lancaster, PABuilt 1966 · S/N 15065437N22385Knutson Wayne R · Thompson, NDBuilt 1968 · S/N 15068248N2238CGorham Wendy J · Grand Rapids, MNBuilt 1953 · S/N 30538N2238DFanoni Michael A · Colfax, CABuilt 1952 · S/N 20390N2238EAtd Pilot Training LLC · Kansas City, MOS/N 17271199N2238HRhodes Mike A · Independence, ORBuilt 1953 · S/N 25644N2238JPearce William · Grants Pass, ORBuilt 1966 · S/N 15065438N2238XStyron Mark A · Pasadena, TXS/N 337-0138N2238YFerrara Edmond · La Puente, CABuilt 1967 · S/N 17700038N22395Morrison Donald D · Santa Clarita, CABuilt 1974 · S/N 17264063N22396Jordan Lennon D · Bartow, FLBuilt 1972 · S/N 21059741N2239GPotter Cleve J · Fresno, CABuilt 1958 · S/N 51539N223APJuliet Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13440N223BECampbell Edward A · Anchorage, AKBuilt 1977 · S/N 17268915N223BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280950N223CKBounds Keith A · Thomson, GABuilt 2004 · S/N 172S9580N223EMKqm Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282252N223HCG206 LLC · San Juan, PRBuilt 2006 · S/N 20608269N223HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 17281112N223LDGaston'S White River Resort Inc · Lakeview, ARBuilt 1965 · S/N U206-0493N223LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9223N223MEChem-Air LLC · Shreveport, LABuilt 2000 · S/N 18280746N223NKWandering Vet LLC · Mccook, NEBuilt 1955 · S/N 26814N223RJCline Larry J · Beeville, TXBuilt 1979 · S/N 18266850
Back to AD 79-10-14 R1