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.

N5732EWynn Josh · Bucyrus, OHBuilt 1978 · S/N 17271929N5733BRobertson Nate Allen · Aiken, SCBuilt 1956 · S/N 33733N5733CDuea Michael J · Savage, MNBuilt 1950 · S/N 19687N5733RWarren Jeffrey · Omaha, NEBuilt 1965 · S/N 17253402N5733TCountry Flyin Inc · Homestead, FLBuilt 1964 · S/N 17251633N5734AEisenbrey Glen T · Greenbank, WABuilt 1956 · S/N 28334N5734ENewton Victor L · Ozona, TXBuilt 1959 · S/N 17234N5734RZ&H Aviation · Portage, MIBuilt 1965 · S/N 17253403N5735RDavis Richard B · Reno, NVFirst renewal noticeBuilt 1965 · S/N 17253404N5736GGagana Aviation LLC · Leander, TXBuilt 1969 · S/N 15071236N5736TSparks Fly LLC · Mount Gilead, OHS/N 17251636N5737EMcdonald Jake V · Bowling Green, MOBuilt 1959 · S/N 17237N5737JSkolnik Adam R · Clermont, FLBuilt 1974 · S/N 18263506N5737RRegistration Pending · Chatham, NYRegistration pendingBuilt 1965 · S/N 17253406N5738CRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1950 · S/N 19692N5738RKury Ernest A · Centerville, IABuilt 1965 · S/N 17253407N5739ADaystar Ltd · Ellsworth, KSS/N 28339N5739CHellie Andrew B · College Place, WABuilt 1950 · S/N 19693N5739EDuggins Terry W · Bremerton, WAS/N 17239N573JCCoffey John L · Iron River, WIS/N 18502396N573JFHuddleston Edward L · Oaktown, INBuilt 1973 · S/N 18052398N573KKTextron Aviation Inc · Wichita, KSS/N 18283370N573NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10941N5740BPash Olin M · Harlan, IABuilt 1956 · S/N 33740N5740GAdventist World Aviation · Wilson, NCBuilt 1969 · S/N 15071240N5740JStonestreet Arlie D Trustee · Pratt, KSBuilt 1974 · S/N 18263509N5741BCansino Ross G · George West, TXBuilt 1956 · S/N 33741N5741EHatley Ralph A · Eagle Creek, ORBuilt 1959 · S/N 17241N5741RJungman Jensen David A · Adel, IAS/N 17253410N5742ADirt Devil Aviation LLC · Bowdon Junction, GAS/N 28342N5742EMarcum Vernon · Huntington, WVBuilt 1959 · S/N 17242N5742TSkyhawkfive LLC · Claremont, NHS/N 17251642N5743EHock Aviation LLC · Culbertson, NEBuilt 1959 · S/N 17243N5743JMidwest Aerial Photography · Galloway, OHBuilt 1970 · S/N P20600643N5743TRay Aviation LLC · Burkett, TXBuilt 1964 · S/N 17251643N5744BMcgrew Robert P III · Red Bluff, CABuilt 1956 · S/N 33744N5744EThwing Randy L · Las Vegas, NVBuilt 1959 · S/N 17244N5744RBrown Dallin N · Scipio, UTS/N 17253413N5744TMorris Charles E · Ft Worth, TXBuilt 1964 · S/N 17251644N5745CShriver Michael C · Caledonia, ILBuilt 1950 · S/N 19699N5745EDicey Charles E · Dothan, ALBuilt 1959 · S/N 17245N5745GPettis Gary D · Lula, GABuilt 1969 · S/N 15071245N5745JJohnson Charles R · Aurora, OHBuilt 1974 · S/N 18263512N5746AManier Byron K · Houston, MOBuilt 1956 · S/N 28346N5746CHince Ambrose · East Troy, WIBuilt 1950 · S/N 19700N5746JPassage Way Farms · Lyon, MSBuilt 1974 · S/N 18263513N5746RKrawietz William L · Bulverde, TXBuilt 1965 · S/N 17253415N5746TWolfe John E · Bay Point, CABuilt 1964 · S/N 17251646N5747BFarris Steve R · Fresno, CABuilt 1956 · S/N 33747N5747RLehmer Jereme D · Oxford, NYBuilt 1965 · S/N 17253416
Back to AD 79-10-14 R1