OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N55PNKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 28-7415251N55PTDejulia Thomas A · Seward, AKBuilt 1953 · S/N 18-2675N55PZVayda Douglas L · Crescent City, FLBuilt 2004 · S/N 9971CCN55RCSmith Matthew E · Creston, IABuilt 1989 · S/N 288N55SHTiedeman Craig L · Seven Bays, WABuilt 1998 · S/N 55-483103N55TBKennedy Michael Allen · Oxnard, CABuilt 1966 · S/N 28-21634N55TWBeyer Arthur J · Cheektowaga, NYBuilt 1976 · S/N 248N55VLDarian Alexander L · Brightwaters, NYBuilt 1979 · S/N AA5B1065N55WAHudgens Terry L · Blockton, IABuilt 1972 · S/N 216N55WCHagan Jeremy D · Madrid, NEBuilt 1975 · S/N AA5B-0216N55XFCeb Enterprises LLC · Petal, MSBuilt 1972 · S/N 28-7325132N56001Citabria LLC · Missoula, MTBuilt 1982 · S/N VAC-184-82N56002Clark William · Gig Harbor, WABuilt 1982 · S/N VAC 185-82N56007N56007 LLC · Burke, VABuilt 1973 · S/N 28-7325553N5600CRegistered aircraftBuilt 1981 · S/N VAC 176-81N5600JHigh Country Aircraft LLC · Westcliffe, COBuilt 1981 · S/N VAC 177-81N5600MClarke Michael J · Baker, FLBuilt 1982 · S/N VAC-183-82N5600UCorey Marlin F · Choctaw, OKBuilt 1966 · S/N 28-22203N5600WFitzgerald Anthony M · Crete, NEBuilt 1962 · S/N 28-737N5600YNelson Kenneth A · Fort Mill, SCBuilt 1982 · S/N VAC188-82N56015Ac Sales & Investments LLC · Hickory, NCBuilt 1973 · S/N 28-7305518N5601GRetzlaff Cathy S · Oshkosh, WIBuilt 1985 · S/N VAC189-85N5601QRegistered aircraftBuilt 1965 · S/N 2999N5601WTaylor Larry J · San Manuel, AZBuilt 1962 · S/N 28-738N5602QWacker Jeremy C · Denver, COBuilt 1965 · S/N 3102N5602WSaunders Nathaniel E · Muskegon, MIBuilt 1962 · S/N 28-739N5603PLitteken David T · Aviston, ILBuilt 1959 · S/N 24-671N5603WElliot Harold F II · Pomeroy, OHBuilt 1962 · S/N 28-740N56041Haddad Joe · Charlotte, NCBuilt 1973 · S/N 28-7325562N5604UShumaker Grant H · Dakota Dunes, SDBuilt 1969 · S/N 28-26532N5604WHustedde Trucking LLC · Fayette, MOBuilt 1962 · S/N 28-741N56055Murray Patrick Calvin Jr · Port Orchard, WABuilt 1973 · S/N 28-7325563N5605JMajor Air LLC · Charleston, SCS/N 17273819N5605PAurnou Marshall E · Marco Island, FLBuilt 1959 · S/N 24-673N5605UN5605u LLC · Nottingham, NHBuilt 1969 · S/N 28-26534N5607UWilliams Richard Dale · Tucson, AZBuilt 1969 · S/N 28-26535N5607WFrost Jack D II · Goodrich, MIS/N 28-745N56083Rock Solid Aviation LLC · Lake Charles, LABuilt 1973 · S/N 28-7325565N5608USchoenberger Amber J · Niceville, FLS/N 28-26537N56090Wood William J · Jackson, GABuilt 1973 · S/N 28-7325570N56098Wong Yi C · Aurora, COBuilt 1973 · S/N 28-7325571N5609LTaylor Darius · Fayetteville, GABuilt 1972 · S/N AA5-0209N5609USteves Landavator Service LLC · Oley, PAS/N 28-26539N560CPStory Charles M · Leesburg, FLBuilt 2002 · S/N 369N560FLBancroft Robert W · Aurora, NYBuilt 1975 · S/N 28-7625026N560PUPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 2842098N560RJJenaero LLC · Cincinnati, OHBuilt 1993 · S/N 7637N560ZHeslin Jon P · Sutton, MABuilt 1974 · S/N 17262889N56105Anderson Wendell R · Brainerd, MNBuilt 1973 · S/N 28-7325573N5610UAnderson Aviation LLC · Bulverde, TXBuilt 1969 · S/N 28-26540
Back to AD 79-10-03 R2