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.

N4737FJelm Gordon E · Aguila, AZBuilt 1978 · S/N 18503552N4737UMoody Properties LLC · Olympia, WABuilt 1964 · S/N 18051437N4738BEarhart Robert E · Dallas, TXBuilt 1955 · S/N 31636N4738GCmk Aerial Inc · Sutton, NES/N 17273335N4738QNeal Tyler W · Dufur, ORBuilt 1967 · S/N 185-1192N4738USw Aviation Services Inc · Queen Creek, AZBuilt 1964 · S/N 18051438N4738XHageness Todd A · Rugby, NDS/N 15064788N4739DMuddy Creek Aviation LLC · Dayton, VAS/N 17272346N4739FEberwine David B · Lucas, TXBuilt 1966 · S/N P206-0339N4739JVero Technical Support Inc · Pensacola, FLBuilt 1979 · S/N 17273672N4739XKimberly Jack L · Shippensburg, PABuilt 1966 · S/N 15064789N473CAWingsleasing LLC · Wichita, KSS/N 172S11738N473CMN473cm LLC · Manassas, VABuilt 2006 · S/N 172S10398N473CSDae Aviation Enterprises Corp · Gilford, NHBuilt 2016 · S/N 172S11673N473EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11600N473KPDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1982 · S/N 172RG1132N473YCU S Department Of The Interior · Boise, IDBuilt 2012 · S/N 20608348N4740BCallahan Brian L Trustee · Kuna, IDBuilt 1955 · S/N 31638N4740EVehorn Richard B · Carrollton, TXBuilt 1982 · S/N 18268264N4740FSkydive Ricks LLC · Petersburg, OHBuilt 1966 · S/N P206-0340N4740NGtz No 1 LLC · Kalispell, MTBuilt 1979 · S/N 18267329N4740QFitzpatrick D L III · Whitefish, MTBuilt 1966 · S/N 185-1194N4741NCimmaron Flying Inc · Colorado Springs, COBuilt 1979 · S/N 18267330N4741XRessel Erik P · Lakewood, COBuilt 1980 · S/N U20605529N47428Nei Jeffrey G · Bemidji, MNBuilt 1966 · S/N 185-1196N4742EHangen Mark C · Flagstaff, AZS/N 18503853N4742NRegistration Pending · Wilmington, DERegistration pendingBuilt 1979 · S/N 18267331N4742UProtocol Enterprises LLC · Holdrege, NEBuilt 1983 · S/N 21064810N4742XMurphy Chong Yi · Fernandina Beach, FLBuilt 1966 · S/N 15064792N4743BAmstrup Norm D · North Pole, AKBuilt 1955 · S/N 31641N4743CFour Three Charlie LLC · Andover, MABuilt 1979 · S/N 21063608N4743DEss Partnership LLC · Waterford, MIBuilt 1957 · S/N 34843N4743ERegistered aircraftBuilt 1982 · S/N 18268265N4743NGallagher Jeff · Rio Oso, CABuilt 1979 · S/N 18267332N4743QHabersetzer Brian D · Brush Prairie, WABuilt 1967 · S/N 185-1197N4743XAerotech Mapping Inc · Las Vegas, NVBuilt 1980 · S/N U20605530N4744CDesert Aviation LLC · Kingman, AZBuilt 1979 · S/N 21063609N4744GJackson Flight Center LLC · Moses Lake, WABuilt 1979 · S/N 17273336N4745DRoman Steven T · Burgettstown, PABuilt 1957 · S/N 34845N4745NHowze William Scott · Robstown, TXBuilt 1979 · S/N 18267333N4746NDenham Stacy L · Chehalis, WABuilt 1979 · S/N 18267334N4746RZurawski Joseph · Ocala, FLBuilt 1979 · S/N 172RG0022N4746U4746u LLC · Sherman Oaks, CABuilt 1979 · S/N U20605079N4747CAlfred Joseph T · Pagosa Springs, COBuilt 1979 · S/N 21063611N4747QRoss Andrew P · Romoland, CAS/N 185-1201N4748DLifting Spirits Research LLC · Pensacola, FLS/N 34848N4748JYecny Enterprises Inc DBA · San Luis Obispo, CAFirst renewal noticeBuilt 1979 · S/N 17273673N4748USmith-Heffernan Heather · Frisco, TXBuilt 1965 · S/N 18051448N4749BNunley Tim L · Palmer, AKBuilt 1955 · S/N 31647N4749XFlaat Stephen C · Bemidji, MNBuilt 1966 · S/N 15064799
Back to AD 79-10-14 R1