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.

N9074GRush Wayne A · Troy, KSBuilt 1971 · S/N 18260614N9074TRollinson Mark H · South CanterburyBuilt 1960 · S/N 52974N9074XDistel Richard G · Loveland, COBuilt 1961 · S/N 18253474N9075AKingdom Air Corps · Sutton, AKBuilt 1949 · S/N 18834N9075MBumback William R · Seattle, WABuilt 1976 · S/N 18264668N90763Apex Aircraft Leasing LLC · Anchorage, AKBuilt 1983 · S/N 17275856N9076AList Oliver · Wasilla, AKBuilt 1949 · S/N 18835N9076MFowler Kenneth R · Locust Fork, ALS/N 18052176N9077ADay Jeffrey R · Haslet, TXBuilt 1949 · S/N 18836N9077TMegilligan Scott M · Johnstown, COBuilt 1960 · S/N 52977N9077XTmax Aviation LLC · Newcastle, WYBuilt 1961 · S/N 18253477N9078MD R I Enterprises Ltd · Decatur, TXBuilt 1977 · S/N 21062060N9079AMandere Mark Edward · Spokane Valley, WABuilt 1949 · S/N 18838N9079GHenriksen Gary L · Sequim, WABuilt 1971 · S/N 18260619N9079HJoey Os LLC · Darlington, PABuilt 1979 · S/N 21063829N9079XWessel Eric B · Peabody, KSBuilt 1961 · S/N 18253479N907AKErickson Michael J Jr · Juneau, AKBuilt 1993 · S/N 18502297N907ATAirglas Inc · Achorage, AKBuilt 1977 · S/N 18265563N907AZN907az LLC · Miami, FLBuilt 1980 · S/N 17274436N907CERoss Peter W Trustee · Lufkin, TXBuilt 1976 · S/N 18503081N907CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8330N907CSSteggerda Scott · Anchorage, AKBuilt 1964 · S/N 18051392N907EEEriksen Eric Edward · South Fork, COBuilt 1961 · S/N 1850087N907EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12916N907FMiller Jonathan L · Anchorage, AKS/N 30647N907GGGleim Education Inc · Gainesville, FLS/N 18255299N907JMWright Flight Inc · Tucson, AZS/N 21063665N907JWPalm Beach Flight Training Corp · Lantana, FLBuilt 2006 · S/N 172S10328N907KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268575N907LMDe Gavere Lambert M · Anchorage, AKBuilt 1974 · S/N 18502372N907LPMicro Publishing Press Inc · Truckee, CABuilt 1999 · S/N 172S8221N907PBMorris Engineering Group Inc · Auke Bay, AKBuilt 1970 · S/N 18260376N907RKKulin Robb M · Anchorage, AKBuilt 1978 · S/N 18052977N907SEAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13479N907TTHangar Ak LLC · Sterling, AKBuilt 1974 · S/N 17262358N907WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1976 · S/N 17267907N907WKNational Aircraft Leasing Corp · Manassas, VAS/N 18282197N9081GIfr Investments LLC · Covington, LABuilt 1971 · S/N 18260621N9081HRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1975 · S/N 17265930N9081MValiair Lc Trustee · Casper, WYS/N 18052181N9081XKardack Michael R · Lopez Island, WAS/N 18253481N9082TFly By Knights Aero Club Inc · Bay City, MIBuilt 1960 · S/N 52982N9083AStorch Shaidon P · Deer Park, WAS/N 18842N9083HNewton Aero LLC · Hurdland, MOBuilt 1974 · S/N 18801829TN9083RStuder Alfred C · Shelby, MIBuilt 1975 · S/N 18802104TN9083XAhl Of Montana LLC · Lolo, MTBuilt 1961 · S/N 18253483N9084FIsland Bound LLC · Dunedin, FLBuilt 1980 · S/N 172RG0352N9084MWinzenried Ryan A · Pedro Bay, AKBuilt 1971 · S/N 18052184N9084XWareh Nabil · Corona, CABuilt 1961 · S/N 18253484N9085GHatley Ralph A · Eagle Creek, ORBuilt 1971 · S/N 18260625
Back to AD 79-10-14 R1