OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N7822DTwinco Leasing LLC · Yacolt, WABuilt 1957 · S/N 22-5468N7822VBarry John J · Bethel, CTBuilt 1964 · S/N 2806N78239Draco Flight School DBA · Chino, CABuilt 1968 · S/N 17257540N7823DBurnopp Jacob A · Evington, VABuilt 1957 · S/N 22-5469N7823GAmerican Patrols Inc · Midland, TXBuilt 1970 · S/N 17259523N7823HCharley Arrie · Gakona, AKBuilt 1946 · S/N 12-723N7823NKaiten Aviation LLC · North Haven, CTBuilt 1968 · S/N 28-5275N7823WCdm Dirt LLC · Snowflake, AZBuilt 1964 · S/N 28-1840N78240Kinney Joan M · Vermillion, SDBuilt 1968 · S/N 17257541N78242176fps LLC · Marthasville, MOBuilt 1968 · S/N 17257543N78249Howard Ronald W · Okeechobee, FLBuilt 1968 · S/N 17257545N7824DWhitaker Samuel M · Brooklet, GABuilt 1957 · S/N 22-5470N7824NMcatarian Mark F · Saint Marys, KSBuilt 1969 · S/N 28-5277N7824WHornbill Aviation LLC · Incline Village, NVBuilt 1964 · S/N 28-1835N78253Chatman Hannah K · Poplar Bluff, MOS/N 17257546N78254Bpk Holdings LLC · Montesano, WABuilt 1968 · S/N 17257547N7825ND&D Vision Air LLC · Aubrey, TXBuilt 1968 · S/N 28-5278N7825WNelson Aaron D · Carver, MNBuilt 1964 · S/N 28-1837N7826681 Escadrille Inc · Hutchinson, KSBuilt 1968 · S/N 17257549N7827CKestrel Aviation LLC · Reno, NVS/N 5317N7827DThree Legged Hog Aviation LLC · Boise, IDBuilt 1957 · S/N 22-5473N7827NBest John P · Goldsboro, NCBuilt 1969 · S/N 28-5280N7827WWoods Perry H · Brownsville, TXS/N 28-1842N78286Marsh David J · Sioux Falls, SDBuilt 1968 · S/N 17257554N7828DDyer Royal J · Melrose, NYBuilt 1957 · S/N 22-5474N7828NBurris Jamey E · Mt Juliet, TNBuilt 1969 · S/N 28-5281N7828WIliff Aircraft Repair And Service Co Inc · Tulsa, OKBuilt 1966 · S/N 28-3759N78295Cofsky Gregory J · Sandwich, MABuilt 1968 · S/N 17257556N78299Jb Aircraft LLC · Anchorage, AKBuilt 1968 · S/N 17257558N7829GKilo Sierra Aviation LLC · Sammamish, WAS/N 17259529N7829NRoth Colin E · Anchorage, AKBuilt 1969 · S/N 28-5282N7829WBormann Charles F · Mooresville, NCBuilt 1964 · S/N 28-1844N782CAChristman Matthew T · Markle, INBuilt 1966 · S/N 28-21849N782FMFmfa Inc · Wilmington, DEBuilt 1981 · S/N 17274667N782GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881464N782SHJtc Aviation LLC · Nashville, TNBuilt 2004 · S/N 3616N782SNKingdom Air Corps · Sutton, AKBuilt 1973 · S/N 17261341N782YBeitler Richard J · Pittsburgh, PABuilt 1978 · S/N M-2004N78302Gardner Christopher · South Saint Paul, MNBuilt 1968 · S/N 17257559N78305Woollen Claude D · Moore, SCBuilt 1968 · S/N 17257562N7830GSkildum&Company LLC · Grand Marais, MNBuilt 1970 · S/N 17259530N7830NGonzalez Braulio A · Bourbonnais, ILBuilt 1969 · S/N 28-5284N7830WWildhaber Andrew W · Coal Creek, COBuilt 1964 · S/N 28-1845N78312Roemer Joanne · Kemah, TXS/N 17257565N7831NRadar Service Terminated LLC · New York, NYBuilt 1969 · S/N 28-5285N7832DCamp Barry G · Lafayette, LAS/N 22-5478N7832VBaker Benjamin D · Catasauqua, PAS/N 2935N7832WRankin Kevin J · Maryville, MOBuilt 1964 · S/N 28-1849N78330Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257567N78331Clifton Jack D · La Junta, COS/N 17257568
Back to AD 79-10-03 R2