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.

N2227YAdam Lewis W · Chiefland, FLBuilt 1967 · S/N 17700027N2227ZTwo Brothers Acquisitions LLC DBA · Perris, CABuilt 1979 · S/N 28-7916391N2228ZThunderbird Aircraft Co · Bloomington, MNBuilt 1979 · S/N 28-7990408N2229ESix Pack Aviation LLC · Pocono Pines, PABuilt 1978 · S/N 17271193N2229QM21 Aircraft Leasing LLC · Morganton, NCBuilt 1977 · S/N 28-7790383N2229UCalifornia In Nice Inc DBA · San Jose, CABuilt 1979 · S/N 44-7995253N2229YWehkamp Air LLC · Ingalls, KSBuilt 1979 · S/N 28-7990378N2229ZGeorge Walker Field Inc DBA · Bedminster, NJBuilt 1979 · S/N 28-7990409N222BBMatz Jeremy L · Toston, MTS/N M-250N222BKDeralex Airways LLC · Miami, FLS/N 17272887N222BVBb Air LLC · Chesapeake, VABuilt 1975 · S/N 17264997N222CDPascual John J · Panama City Beach, FLBuilt 1999 · S/N DHS-4N222DLMattocks Mary E · East Amherst, NYBuilt 1971 · S/N 28-7125422N222EWGuzman Steven M · Port Saint Lucie, FLS/N 23-1539N222FLPerkins Dwight L · Oklahoma City, OKBuilt 1970 · S/N 28-26582N222GDSolverson Aircraft Management LLC · Waunakee, WIS/N 2185N222GHConcho Aviation LLC · Sterling City, TXS/N 0714N222HERound Engine Aero · Nashville, MIBuilt 1978 · S/N 17271191N222HUPlane Nutz LLC · Sugar City, IDBuilt 2003 · S/N 2238N222JGNoyes Jeffery A · Bridgeport, TXBuilt 1959 · S/N TD-215N222KKBymers Gary E · Waunakee, WIS/N 222N222KMKomoroski Edward J · Frenchtown, NJBuilt 1990 · S/N 337N222KSTriple Two Inc · Wilmington, DEBuilt 1976 · S/N 28-7790270N222MJHonore Breen Aviation LLC · Allegan, MIS/N 12-1905N222NARodriguez Lukas · River Oaks, TXBuilt 1974 · S/N 28-7415226N222NDPlane Nonsense Inc · Middletown, DEBuilt 2001 · S/N 2842111N222NLLawson Lonnie B II · Linden, PABuilt 2001 · S/N 25137N222NYCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276473N222PJSchroeder James L · Rapid City, SDBuilt 1973 · S/N 28-7305259N222PWWelch Michael C · El Dorado Hills, CABuilt 1990 · S/N 155N222RVWyatt Jacob A · Ogallala, NEBuilt 1992 · S/N 2305N222TMJtm Ranches Equipment LLC · Dallas, TXBuilt 1981 · S/N 18-8109081N222TRHarper David E · Stillwater, MNBuilt 1946 · S/N 108-322N222UClukey David Alan · Bryant Pond, MEFirst renewal noticeBuilt 1957 · S/N 23-912N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491N222WGWalker Scott Aviation LLC · Woodward, OKBuilt 1978 · S/N M-2092N2230TWhite Pelican LLC · Union City, TNBuilt 1971 · S/N 28-7105189N2230XPoff Matthew W · Miramar Beach, FLBuilt 1979 · S/N 28-7990374N2232ASummit Air LLC · Clarks Summit, PABuilt 1976 · S/N 28-7690460N2232BLucky Dog Land Co LLC · Caldwell, IDBuilt 1990 · S/N 512N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195N2232LDodson Jack Yii · Douglasville, GABuilt 1976 · S/N MB-819N2232NKnoll Guenter Wilhelm · Belton, SCBuilt 1979 · S/N 28-7990283N2232WJkj Aviation · Wilmington, NCBuilt 1979 · S/N 28-7916334N2233BRollin Virginie C · Mountain House, CABuilt 1978 · S/N 28-7816598N2233CFreeland Robert D · Victor, MTBuilt 1978 · S/N 28-7990147N2233PAeroplanes Over Idaho · Caldwell, IDS/N 23-842N2233XSpector Arnold · Stamford, CTBuilt 1979 · S/N 28-7990368N2234FMoore Aviation LLC · Cedar Springs, MIBuilt 1978 · S/N 28-7990207N2234PDanhauer Jeffrey · Owensboro, KYBuilt 1974 · S/N 761-74
Back to AD 79-10-03 R2