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.

N94812James Hamilton Construction Co · Silver City, NMS/N 18266517N9481AScholl Jonathan W · Mckinney, TXBuilt 1949 · S/N 15302N9481BPueppke Clinton · Ayr, NDBuilt 1958 · S/N 55281N9481CWhitby Christopher W · Prescott, AZBuilt 1955 · S/N 31879N9481DBoemig Madison K · Dalton, NHBuilt 1985 · S/N 172RG1181N9481UParnell Jr Jerry · Panama City, FLBuilt 1976 · S/N 15078429N9481X2310 Woodcrest LLC · Freeland, PABuilt 1961 · S/N 21057781N94823Black Hills Information Security Inc · Bozeman, MTBuilt 2013 · S/N 18282363N94825Vaughan Aviation LLC · Leesburg, VABuilt 2013 · S/N 18282324N9482MWestwind Aviation Inc · Phoenix, AZBuilt 1981 · S/N 20700698N9482RWindy Lane Farms Transport LLC · Mulberry, INBuilt 1975 · S/N 18802292TN9482UClark Josh D · Morehead, KYBuilt 1976 · S/N 15078430N9482ZChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280455N94837Leyser Joshua F C · Tega Cay, SCS/N 18266521N9483HDelbrocco Christopher A · Waitsfield, VTBuilt 1981 · S/N 18267955N9483YSioux Falls Technology LLC · Sioux Falls, SDBuilt 1981 · S/N 21064520N9484ABrown Glen S · Aberdeen, MSBuilt 1949 · S/N 15305N9484CKnowles Jayson C · Winter Harbor, MEBuilt 1955 · S/N 31882N9484HN9484h LLC · Wheeling, ILBuilt 1975 · S/N 17266175N9484XD&J Air Adventures Inc · Koloa, HIBuilt 1985 · S/N 18268537N94853Middle Georgia Aviation Services LLC · Warner Robins, GABuilt 1978 · S/N 18266523N94854Sutliff John K · Walla Walla, WAS/N 18266524N9485ABeam David M · Sabina, OHBuilt 1949 · S/N 15306N9485BLuggar Michael D · Leonard, MNFirst renewal noticeBuilt 1958 · S/N 55285N9485RStevenson Flying Service LLC · Selden, KSBuilt 1975 · S/N 18802294TN9485XBruckman Monty D · Edgewood, NMBuilt 1961 · S/N 21057785N9485ZAtp Aircraft 1 LLC · Wilmington, DEBuilt 1998 · S/N 17280339N9486ASimonson David C · Iron River, WIS/N 15558N9486BMccoy Robert P · Fairbanks, AKBuilt 1981 · S/N 172RG0837N9486GAndrew Odean T · Willow, AKBuilt 1971 · S/N U20601686N9486HStegehuis Richard L · Helenville, WIBuilt 1981 · S/N 18267957N9486RAnderson Aerial Spraying Serv Inc · Canby, MNBuilt 1975 · S/N 18802295TN9486XSchilling Aviation Services LLC · Salina, KSBuilt 1961 · S/N 21057786N94872Weber Brian T · Hastings, MNBuilt 1978 · S/N 18266527N9487AMccown Bill · Dripping Springs, TXBuilt 1949 · S/N 15308N9487BFord Christian G · Pasco, WAS/N 55287N9487UCallejo Joseph S · Port Saint Lucie, FLBuilt 1976 · S/N 15078435N9488ARadke Harlow · Hastings, MNBuilt 1949 · S/N 15309N9488GTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17273629N9488MAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264771N9488UGardner Christopher · Addison, TXBuilt 1976 · S/N 15078436N94897Baca Raymundo · El Paso, TXBuilt 1978 · S/N 18266530N9489ASmith Paul H · Byron, GAS/N 15310N9489TRegistered aircraftRegistration pendingBuilt 1960 · S/N 57289N9489URodriguez Alonso Jr · Alamo, TXBuilt 1976 · S/N 15078437N9489XRegistration Pending · Libby, MTRegistration pendingS/N 21057789N9489ZMoody Bible Institute Of Chicago · Spokane, WABuilt 1981 · S/N U20606525N948CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282115N948RRed Baron LLC · Middletown, DEBuilt 1978 · S/N 177RG1318N948SMScenic Concepts LLC · La Crosse, WIBuilt 1982 · S/N 172RG1057
Back to AD 79-10-14 R1