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.

N45281Stewart Patrick D · Reading, MIBuilt 1975 · S/N 15076822N45284Kelley Keith B · Forney, TXBuilt 1975 · S/N 15076823N45285Bennett Aaron K · Pulaski, VAS/N 15076824N4528BHayton James B · Sedro Woolley, WABuilt 1955 · S/N 31427N4528CMcgough N C · Ferris, TXBuilt 1953 · S/N 25472N4529CVandenbelt Kenneth J · Leslie, MIBuilt 1953 · S/N 25473N452CPCivil Air Patrol · Montgomery, ALBuilt 2013 · S/N 18282368N452EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11586N452JSOffroad Aviation LLC · Las Vegas, NVBuilt 1963 · S/N 18255172N452KKramarich Kenneth · Wintersville, OHBuilt 2024 · S/N 18283284N452SMChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10528N45302Missinne Brett R · South Range, WIBuilt 1975 · S/N 15076832N45308Berry Thomas F · Emmett, IDBuilt 1975 · S/N 15076833N4530BMichael Anna B · Daytona Beach, FLBuilt 1955 · S/N 31429N4530CO Connor Mary B · Anchorage, AKBuilt 1953 · S/N 25474N4530EAig Aeronautics LLC · San Juan, PRBuilt 1978 · S/N 17271621N4530FBean David L · Chandler, AZBuilt 1966 · S/N 185-1015N4530UWorthington Gary · Swifton, ARBuilt 1964 · S/N 15060530N45312Heap Agriculture Service LLC · Stronghurst, ILBuilt 1976 · S/N 177RG1102N4531CGear N The Well LLC · Melbourne, FLBuilt 1953 · S/N 25475N45327Cullen Richard J · Oshkosh, WIS/N 15076845N45328N45328 LLC · Naples, FLS/N 15076846N4532CHopkins Daniel E · Chandler, AZBuilt 1953 · S/N 25476N45335Keeney Daphne C · Fairbanks, AKBuilt 1975 · S/N 15076852N45336Kelley Joshua S · Anchorage, AKBuilt 1976 · S/N 177RG1107N4533BHastie William B · Anchorage, AKBuilt 1955 · S/N 31432N4533CBerwick Robert G · Sonoma, CABuilt 1953 · S/N 25477N45341Taylor Robert S · Satsuma, ALS/N 15076857N45342Skybound Aviation LLC · Bixby, OKBuilt 1975 · S/N 15076858N45349Wall Johan D · Brookston, TXBuilt 1976 · S/N 177RG1109N4534BHornung Chet R · Nikiski, AKBuilt 1955 · S/N 31433N4534E34 Echo Group · Spring Branch, TXBuilt 1978 · S/N 17271622N4534FSmith Peter A · Gunnison, COBuilt 1966 · S/N 185-1019N45350Kelley Konrad E · Grant Valkaria, FLS/N 15076863N45351Dallas Permian LLC · Mckinney, TXBuilt 1975 · S/N 15076864N45359Clapp Edwin G III · Fargo, NDBuilt 1976 · S/N 177RG1112N4535FRohde Allen G · Eagle River, AKBuilt 1966 · S/N 185-1021N45361Price Gregory D · Frankfort, ILBuilt 1975 · S/N 15076874N45364Boren James Mason · Jasper, ALBuilt 1975 · S/N 15076876N45367Christensen Robert T · Presho, SDBuilt 1976 · S/N 177RG1113N45375Eastern Slope Aviation Academy · North Conway, NHBuilt 1975 · S/N 15076885N45376Jones Sharon J · Faulkton, SDFirst renewal noticeBuilt 1975 · S/N 15076886N4537BNewsom William A · Cheraw, SCBuilt 1955 · S/N 31436N45385Steklenski Philip G · Olympia, WABuilt 1977 · S/N 177RG1117N4538CSelby Gerald A · Sand Springs, OKBuilt 1952 · S/N 25482N4538EGrasshopper Flying Club Inc · Poughkeepsie, NYBuilt 1978 · S/N 17271623N4538FLohse Teal K · Cordova, AKBuilt 1966 · S/N 185-1025N45393Currie Grant · Hermosa Beach, CABuilt 1975 · S/N 15076900N45395Holmgren Michael G · Kulm, NDBuilt 1975 · S/N 15076902N45398Tundra Wolf Inc · King Salmon, AKFirst renewal noticeS/N 15076905
Back to AD 79-10-14 R1