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.

N7877ZRussell Jason · Melbourne, FLBuilt 1963 · S/N 15059977N78785Peck John M · Melrose, MTBuilt 1968 · S/N 17257759N78789Hooper Dan B · Zanesville, OHBuilt 1968 · S/N 17257761N7878WRegistered aircraftBuilt 1978 · S/N 18052936N78797Allen Stephanie R · Mukilteo, WABuilt 1968 · S/N 17257767N78799Aerolanding LLC · Enterprise, ALS/N 17257768N7879GComposite Systems Inc · Lake Worth, FLBuilt 1970 · S/N 17259579N7879XCopeland David R · Little Rock, ARBuilt 1961 · S/N 17248379N787AECoordinate Productions LLC · Waterloo, IABuilt 1972 · S/N 21059799N787AGGrenie Arles A · Richland Center, WIS/N 19122N787ATCentral Virginia Flyers Flying Club Inc · Glen Allen, VABuilt 1976 · S/N 17267881N787CPArnett Wallace · Sullivan, INBuilt 1968 · S/N 17257760N787DAMeade Gregory J · Santa Margarita, CABuilt 1966 · S/N 18257284N787DCChavers Seaborn W Jr · Stamping Ground, KYBuilt 1980 · S/N 18267611N787DDHyde James C · Clifton, VABuilt 1977 · S/N 18265896N787FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13164N787GLTfa Holding Corp · Daytona Beach, FLBuilt 2007 · S/N 172S10577N787JABole David M · Auburn, WABuilt 1973 · S/N 15074546N787KBReus Mark J · Alto, MIBuilt 1964 · S/N 17251855N787LFH&R Aviation LLC · West Linn, ORBuilt 2011 · S/N 172S11125N787MDGeorgia Forestry Commission · Macon, GABuilt 2011 · S/N 18282308N787SPSierra Tango Ventures LLC · Monte Sereno, CABuilt 2001 · S/N 172S8714N787WTSemper Supra Air LLC · Ashland City, TNBuilt 1978 · S/N 17271319N787WWDye Kent · Washington, PABuilt 2000 · S/N 172S8589N78801Stone William · Lexington, KYBuilt 1973 · S/N 18261785N78804Whitt James M · Meadowview, VABuilt 1968 · S/N 17257772N78805Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 17257773N78808Ginter Michael J · Oakland, MDBuilt 1968 · S/N 17257774N7880EBootz Terry A · Canyon Lake, TXBuilt 1959 · S/N 17680N7880GGhegan John · Wilmer, ALBuilt 1970 · S/N 17259580N7880THaskins Matthew D · Muskegon, MIBuilt 1960 · S/N 47480N7881FNorman Robert A · Zanesville, OHBuilt 1966 · S/N 15063981N7881GSmith John T · Greenfield, INBuilt 1970 · S/N 17259581N7881NU S Air Force-Owner · Holloman Afb, NMBuilt 1967 · S/N R172-0272N7881UN7881u LLC · Mcminnville, ORBuilt 1976 · S/N 15077854N7881ZSims Abner D · Blackfoot, IDBuilt 1963 · S/N 15059981N7882AWayner Paul S · Anchorage, AKBuilt 1957 · S/N 32779N7882NUnited States Air Force · Kirtland Afb, NMBuilt 1967 · S/N R172-0273N7882XDefenbau James · Sierraville, CABuilt 1961 · S/N 17248382N7882ZTumino Michelle R · Tyler, TXS/N 15059982N78830Frederick Wayne Schultz · Bradley, ILBuilt 1968 · S/N 17257782N78834Barron Ted L · Hoover, ALBuilt 1968 · S/N 17257783N7883EMcentire Ronald · Adams, ORS/N 17683N7883GPhillips Douglas C · Ephrata, PABuilt 1973 · S/N 15074734N7883XRegistration Pending · Derby, KSRegistration pendingS/N 17248383N7883ZJacobson Billy J III · Severance, COBuilt 1963 · S/N 15059983N78842Helice Sarcelle LLC · San Antonio, TXBuilt 1968 · S/N 17257787N78846Aero Investors Lc · Jackson, MIS/N 17257788N7884AMcintyre Jon D · Fairbanks, AKBuilt 1957 · S/N 32781N7884ERabenberg Travis T · Lowell, MIBuilt 1959 · S/N 17684
Back to AD 79-10-14 R1