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.

N6675FCommercial Center Inc · Wilmington, DEBuilt 1966 · S/N 15063275N6675MMorrissette Todd · Buxton, MEBuilt 1975 · S/N 18263795N6675TYoung Dan J · Norwalk, IABuilt 1960 · S/N 15059075N66764Cuttler Lloyd · Carabaset Vly, MEBuilt 1978 · S/N 18052958N66765Kalba Shaun B · Pleasant Valley, NYBuilt 1978 · S/N 18052959N66768Ludemann John K · Enfield, CTBuilt 1974 · S/N 15076262N6676FCampbell J R Jr · Bell, FLBuilt 1966 · S/N 15063276N6676GChen Hong · Independence, ORBuilt 1970 · S/N 15072176N6676TCash W Duane · Fairfield Bay, ARS/N 15059076N66774Kilo Lima LLC · Hicksville, NYBuilt 1974 · S/N 15076268N66776Broherd James · Natalia, TXBuilt 1974 · S/N 15076269N66777Lennon Bobby M · Whiteville, NCS/N 15076270N66779Blinn Philipp Randy · Priest River, IDS/N 15076272N6677BHess Chad · Boise, IDBuilt 1978 · S/N 21062816N6677EEmery Edward L · Marysville, WABuilt 1959 · S/N 56177N6677HPeterson Robert E · Richland, WABuilt 1975 · S/N 17265533N6677RTre Aviation Corp · Wilmington, DES/N 21059654N6677TStewart Greg Lee · Bottineau, NDS/N 15059077N6677XMuhlenbrock Guillermo Rene Jr · Las Vegas, NVS/N 21057677N66780Keenan Jim F · Neenah, WIBuilt 1974 · S/N 15076273N66781Strong Mack A · Coral Springs, FLS/N 15076274N66785Destefano Patrick S · Bryan, TXBuilt 1974 · S/N 15076278N66786Gibb Bryce M · Portland, TXBuilt 1974 · S/N 15076279N6678XKinman Kary Wade · Panama City Beach, FLBuilt 1961 · S/N 21057678N66790Logan Dan P · Gilliam, LABuilt 1974 · S/N 15076283N6679SCampos Katherine · Tallahassee, FLBuilt 1967 · S/N 15067479N667ARRegistered aircraftBuilt 1977 · S/N 18265379N667BCWithrotor Aviation Inc · Lakeview, ORBuilt 1979 · S/N 18503849N667BLClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13555N667CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 18283236N667EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12556N667PBButzin Paxton E · Wild Rose, WIBuilt 1951 · S/N 20116N667SPHindi David · Cupertino, CABuilt 1998 · S/N 172S8070N667WBMcleod Patrick J · Overgaard, AZBuilt 1967 · S/N 18258563N6680BBush Douglas B · Santa Rosa Beach, FLBuilt 1978 · S/N 21062818N6680EPrax Philip · Fairbanks, AKBuilt 1959 · S/N 56180N6680MMcshane Shannon K · Alamo Heights, TXBuilt 1975 · S/N 18263796N6680TParsons Joshua A · Hollis Center, MEBuilt 1960 · S/N 15059080N6681ACarignan Armand R · Hooksett, NHBuilt 1956 · S/N 28781N6681EFoisy Douglas · Burleson, TXBuilt 1959 · S/N 56181N6681GMoore Joseph L · Hesperus, COS/N 15072181N6682XDuff John W · Alligator, MSBuilt 1960 · S/N 21057682N6683EBergeson John S · Rhome, TXS/N 56183N6683GPardee Gary D · Buckley, WABuilt 1970 · S/N 15072183N6683SWingsofdawn LLC · East Greenwich, RIBuilt 1967 · S/N 15067483N6683THecker Darin S · Grants Pass, ORBuilt 1960 · S/N 15059083N6684ASchumacher Leroy H · Beach City, OHBuilt 1956 · S/N 28784N6684ERound Engine Aero · Nashville, MIS/N 56184N6684GReeder Brenton Lamar · Beacon, NYBuilt 1970 · S/N 15072184N6684MMlynarczyk Stanley · Darien, ILBuilt 1975 · S/N 18263798
Back to AD 79-10-14 R1