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.

N4317GCendejas Agustin · Chino, CAFirst renewal noticeBuilt 1983 · S/N 28-8416003N4317JMiller Anthony J · Rexford, MTBuilt 1967 · S/N 28-22691N4317QPerera Nandana L · Logan, OHBuilt 1971 · S/N 17260217N4317RSam Aviation LLC · Long Beach, CAS/N 17263070N4317TSpanku LLC · Bay Shore, NYBuilt 1983 · S/N 28-8490002N43181New Mexico Flying Eagle Inc DBA · Tucson, AZS/N 28-7415442N43186Aerolina Inc · Hendersonville, NCBuilt 1983 · S/N 28-8416008N43187Frederick Aero Club Inc · Wilmington, DEBuilt 1983 · S/N 28-8490006N4318BFaith Flyers Inc · Wellington, FLBuilt 1983 · S/N 28-8490004N4318RBeaulieu Steven · Georgetown, DEBuilt 1974 · S/N 17263071N4318ZDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 28-8416007N4319DPumphrey Anthony D Sr · Little Rock, ARBuilt 1983 · S/N 28-8490007N4319XEagle Eye Aerial Imaging LLC · Chagrin Falls, OHBuilt 1975 · S/N 28-7690002N4319YRock Solid Aviation LLC · Lake Charles, LABuilt 1983 · S/N 28-8490010N431EAHamilton Dale N · Grand Rapids, MIBuilt 1991 · S/N 05N431FDahlin Joel R · Saint Paul, MNBuilt 1968 · S/N 28-24929N431RAJimenez Raymond C · Gardena, CABuilt 1990 · S/N 31N431RMPierzchalski Aidan K · Stevenson Ranch, CABuilt 2004 · S/N 2843600N431SMPongracz Brian · Redding, CABuilt 2002 · S/N 90409N43200Robertson Charles V II · Amarillo, TXFirst renewal noticeBuilt 1974 · S/N 28-7425344N43201Paul Richard · Fresno, CAS/N 28-7415443N43206Hower Phillip G · Seabeck, WABuilt 1974 · S/N 28-7415444N43208Thornburgh Paul J Trustee · Sun Prairie, WIBuilt 1974 · S/N 28-7415445N4320AKnutson Daniel T · Lodi, WIS/N 22-3672N4320FSkippys Sky Scooter LLC · Jenks, OKBuilt 1976 · S/N 28-7715016N4320JHaddle Eddie · Lindon, UTBuilt 1967 · S/N 28-22694N4320MKoinzan Flying Service Inc · Elgin, NEBuilt 1947 · S/N 12-3256N4320ZSchermerhorn Lee V D III · Oak Harbor, WABuilt 1968 · S/N 18-8633N43214Bellard Cedric · Valrico, FLBuilt 1974 · S/N 28-7415446N43218On Final Aviation LLC · Brookland, ARBuilt 1974 · S/N 28-7425345N43219Stading William T · Hackensack, MNBuilt 1974 · S/N 28-7415447N4321JN51343 LLC · Newnan, GABuilt 1967 · S/N 28-22695N4321QW H Flying Club Inc · Kingston, MIS/N 17260221N43221Bednarz Joseph P · Hendersonville, TNBuilt 1974 · S/N 28-7405181N43224Piper Aviation LLC · Tierra Verde, FLBuilt 1974 · S/N 28-7425346N4322GMid Atlantic Air Museum · Reading, PABuilt 1971 · S/N 032N4322JDougherty Joseph P · Hughesville, PABuilt 1967 · S/N 28-22696N4322XManitowoc Flyers Corp · Manitowoc, WIBuilt 1975 · S/N 28-7690015N4322ZLee Gerald R · Glennallen, AKBuilt 1968 · S/N 18-8636N43232N43232 LLC · Orange, TXBuilt 1974 · S/N 28-7415450N43234Level Up Aviation LLC · Newton, ALBuilt 1974 · S/N 28-7415451N4323QWausau Flying Service Inc · Wausau, WIBuilt 1971 · S/N 17260223N4323RMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263076N4323XRegistered aircraftBuilt 1975 · S/N 28-7690016N4323ZDubious Adventures LLC · Big Lake, AKS/N 18-8638N43240O'Quinn Kayla M · Jesup, GABuilt 1974 · S/N 28-7405182N43241Atmospheric Vehicle & Spacecraft Flight Exploratio · Rch Palos Vrd, CAS/N 28-7425349N43243Gomez Herbert · Holdenville, OKBuilt 1974 · S/N 28-7415453N43247Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 28-7415456N4324HTrott James E · Cathlamet, WAS/N 185569
Back to AD 79-10-03 R2