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.

N9132UBishop Michael J · Poulsbo, WABuilt 1976 · S/N 15078083N9133AMeyer Jeremy · Conway Springs, KSBuilt 1949 · S/N 18892N9133CPowers Gene Carroll · Kennedale, TXBuilt 1954 · S/N 31232N9133MJones Ezra B III · Atlanta, GABuilt 1976 · S/N 18264693N9134BJohnson Andrea J · Redlands, CABuilt 1958 · S/N 36734N9134GHoworth Earl J · Gainesville, GABuilt 1971 · S/N 18260674N9134HRegistration Pending · Kalispell, MTRegistration pendingS/N 17265964N9134QAviation Specialty Services LLC · Beaufort, NCBuilt 1968 · S/N 337-M0185N9134XDardas Thomas M · West Peterborough, NHBuilt 1961 · S/N 18253534N9135CLowlo LLC · Salt Lake City, UTBuilt 1954 · S/N 31234N9135GRay James O III · Mc Rae, GABuilt 1971 · S/N 18260675N9135MHall John Douglas · Zachary, LABuilt 1976 · S/N 18264695N9135XTingley Thomas A · Groveland, CAFirst renewal noticeBuilt 1961 · S/N 18253535N9136CLanier Scott R · Fairbanks, AKBuilt 1954 · S/N 31235N9136GFredenburg Kenneth D Trustee · Gilroy, CABuilt 1971 · S/N 18260676N9136TMarble Jere D · Dayton, NVBuilt 1959 · S/N 50636N913769-Six Inc · Zortman, MTBuilt 1973 · S/N 18261990N91377Webster Marc · Glendale, CABuilt 1973 · S/N 18261991N9137BMeyer David E · Olathe, KSBuilt 1958 · S/N 36737N9137CKingdom Air Corp · Sutton, AKBuilt 1954 · S/N 31236N9137GGulf Coast Helicopters Inc · Pearland, TXBuilt 1971 · S/N 18260677N9137HPilots Flying School LLC · Englishtown, NJBuilt 1975 · S/N 17265966N9137MRiverside Pilots Inc · Riverside, CABuilt 1976 · S/N 18264697N9138GTlc Flying Inc · Colfax, WABuilt 1973 · S/N 18801390N9138HMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265967N9138RDuricka Richard · Spokane, WAS/N 52063N9138TKnopp Steven L · Camano Island, WABuilt 1959 · S/N 50638N9138XVictor Valley College · Victorville, CABuilt 1961 · S/N 18253538N91390Walters Leif C · Wasilla, AKBuilt 1969 · S/N 18052060N91393Boniek Martin J · Glennallen, AKBuilt 1969 · S/N 18052063N91394Mckay John B · Wenatchee, WABuilt 1969 · S/N 18052064N91397Lucero Andrew R · Duluth, MNBuilt 1969 · S/N 18052067N91399Copper River Airmotive LLC · Copper Center, AKBuilt 1969 · S/N 18052069N9139BFikes Richard Glen III · Flint, TXS/N 36739N913CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8333N913DHWarren Rodney L · Hobbs, NMBuilt 1968 · S/N 18259017N913MAKennedy Michael J · Gilbert, AZBuilt 1999 · S/N 17280777N913NTCorrao David A · Reno, NVBuilt 1979 · S/N 18267268N91406Wimmer Luke R · Rogers, TXS/N 18261997N9140BBunney Jared · Spokane Valley, WAS/N 36740N9140RGilliland Allen N · King Salmon, AKBuilt 1960 · S/N 30207N9140ULegore William G · Windsor, WIBuilt 1976 · S/N 15078091N91415Hangar R LLC · Irvington, ALBuilt 1973 · S/N 18261999N9141ABarinaga Charles J · West Richland, WABuilt 1949 · S/N 18902N9141BBurnham Gary · Helper, UTBuilt 1958 · S/N 36741N9141CWeir Jimmy S · Anchorage, AKBuilt 1954 · S/N 31240N9141MSkyview Aviation LLC · Tracy, CABuilt 1976 · S/N 18264699N9141XFowler-Carpenter Shirley · San Antonio, TXBuilt 1961 · S/N 18253541N91427Curry Phillip S · Seal Beach, CABuilt 1973 · S/N 18262000N9142GRegistered aircraftBuilt 1971 · S/N 18260682
Back to AD 79-10-14 R1