AD 79-10-14 R1

Registered aircraft · 56,582

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.

N736RUGlaeser Robert L · Portland, ORBuilt 1977 · S/N R1722736N736RVPerrin J R · Omaha, NEBuilt 1977 · S/N R1722737N736RWHoward County Flying Club Inc · Grand Island, NEBuilt 1977 · S/N R1722738N736RXTop Notch Services LLC · Glen Cove, NYBuilt 1977 · S/N R1722739N736RZShipol Flying LLC · Sacramento, CABuilt 1977 · S/N R1722741N736SCGolf Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13437N736SDJcp Thrift Inc · Ocean Springs, MSS/N R1722745N736SEJones Harry N · Kathleen, GABuilt 1977 · S/N R1722746N736SKHawe Christopher · Homer, AKBuilt 1977 · S/N R1722751N736SLLang Inc · Wilmington, DEBuilt 1977 · S/N R1722752N736SPColberg Stefan · North Bend, ORBuilt 1977 · S/N R1722755N736SXWalls Chris K · Lawrenceville, GABuilt 1977 · S/N R1722762N736SYGosch Peter J · Littleton, COBuilt 1977 · S/N R1722763N736TASlc LLC · Las Vegas, NVBuilt 1977 · S/N R1722765N736TCJia Li · Chandler, AZS/N R1722767N736TELissie Flying Service Inc · Lissie, TXBuilt 1977 · S/N R1722769N736TP4110 Aviation LLC · Rome, GABuilt 1977 · S/N R1722778N736TTWillard Michael E · Colorado Springs, COBuilt 1977 · S/N R1722782N736TUMathwig Althea G · Glencoe, MNBuilt 1977 · S/N R1722783N736TVRegistration Pending · Mocksville, NCRegistration pendingBuilt 1977 · S/N R1722784N736TXN736 Tango Xray LLC · Paw Paw, ILBuilt 1977 · S/N R1722785N736UASandstrom Jeff A · Anchorage, AKBuilt 1977 · S/N R1722788N736UBMccall Freddie · Brewton, ALBuilt 1977 · S/N R1722789N736UETraining Planes Of Texas Inc · Flint, TXBuilt 1977 · S/N R1722792N736UFLee County Flying Club LLC · Marianna, ARBuilt 1977 · S/N R1722793N736UGAerospatiale LLC · Yakima, WAS/N R1722794N736UJN736uj LLC · Tulsa, OKBuilt 1977 · S/N R1722796N736UKMustard Robert M · Duxbury, MAS/N R1722797N736UPDavis John F · Westminster, MDS/N R1722801N736UTIsbell Brian K · Rosenberg, TXBuilt 1977 · S/N R1722804N736UUCoffyn Clifford J · Boynton Beach, FLBuilt 1977 · S/N R1722805N736VAFelmlee Don E · Center, COS/N R1722811N736VBBuell Jack A · St Maries, IDBuilt 1977 · S/N R1722812N736VDJ-Mac Aviation LLC · Hugoton, KSBuilt 1977 · S/N R1722814N736VELesure William A · Wadsworth, OHS/N R1722815N736VGDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1977 · S/N R1722817N736VJFly White Cloud LLC · Lake Havasu City, AZBuilt 1977 · S/N R1722819N736VLKaehlert Lottie DBA · Rifle, COS/N R1722821N736VPKitty Hawk Flight Training And Tours LLC · Kill Devil Hills, NCBuilt 1977 · S/N R1722824N736VRStalling Dustin R · Florence, AZS/N R1722826N736VWDorsey Jerome J · Greensboro, PAS/N R1722831N736VXRocky Mountain Flight Consultants LLC · Boulder, COBuilt 1978 · S/N R1722832N736VZSuarez Santiago A · Laredo, TXS/N R1722834N736WCNash Jason · Barrington, NHBuilt 1977 · S/N R1722837N736WEContinental Capital Corp · Wilmington, DEBuilt 1977 · S/N R1722839N736WJRatjen Aviation LLC · Naples, FLBuilt 1977 · S/N R1722843N736WKRegistration Pending · Jenks, OKRegistration pendingBuilt 1978 · S/N R1722844N736WLInman James F · East Bend, NCBuilt 1977 · S/N R1722845N736WSMst Ltd · Charlotte, NCBuilt 1977 · S/N R1722851N736XAReese Brent R · Anchorage, AKBuilt 1978 · S/N R1722859
Back to AD 79-10-14 R1