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.

N808RLCtr Assets LLC · Dawsonville, GABuilt 1963 · S/N 205-0467N808TPAvian Leasing LLC · Bremerton, WABuilt 1997 · S/N 17280141N808UFMahoney Clinton D · Tecumseh, NEBuilt 1975 · S/N 17264869N808ZTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608236N80906Red Door Aviation LLC · Dover, DEBuilt 1976 · S/N 17266796N80912Bay Area Concrete LLC · Hayward, CABuilt 1976 · S/N 17266798N80914Cp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 17266799N8091AHonrud Joseph C · Cal Nev Ari, NVBuilt 1952 · S/N 20943N8091EChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172-75486N8091GWood Kim W · Tucson, AZBuilt 1971 · S/N 177RG0091N8091LSzarek Carlee B · Los Osos, CABuilt 1967 · S/N 17256291N8091ZFahlbusch Marius J · Snohomish, WABuilt 1966 · S/N U206-0491N80921Conerly Group LLC · Denham Springs, LABuilt 1976 · S/N 17266803N80928Bellingham Aviation Services LLC · Bellingham, WABuilt 1976 · S/N 17266804N8092BHering Robert A · Anchorage, AKBuilt 1957 · S/N 29892N8092TFlying Colors Airparts Inc · Leesburg, FLBuilt 1961 · S/N 17556792N8092VRohm Arne · Miller, MOBuilt 1974 · S/N A1500526N80931Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266806N8093FHardy Peter Nicholas · Los Osos, CABuilt 1966 · S/N 15064193N8093LNevins Mark B · Gresham, ORBuilt 1967 · S/N 17256293N8093TScholl Adam J · Garretson, SDBuilt 1960 · S/N 17556793N80941Holombo Ray J · Taylors, SCBuilt 1976 · S/N 17266810N8094BRutherford County Air Rescue Squad · Rutherfordton, NCBuilt 1957 · S/N 29894N8094GTri Rotor Spray & Chemical · Ulysses, KSBuilt 1973 · S/N 18801230N8094TMapes Rocky A · Thornton, COS/N 17556794N8094XJenkins Matthew · Bend, ORS/N 17248594N80952Registered aircraftBuilt 1976 · S/N 17266817N80959Mets Flying Club Inc · Fairmount, INBuilt 1976 · S/N 17266819N8095BYeagley Daun E III · Moraine, OHBuilt 1957 · S/N 29895N8095SKimball James D · Osceola, IABuilt 1965 · S/N 15061695N8095TCarter Audie L · Port Saint Lucie, FLFirst renewal noticeBuilt 1960 · S/N 17556795N8095XBall Christopher B · Homer, AKBuilt 1961 · S/N 17248595N80961A S Air LLC · Lantana, FLBuilt 1976 · S/N 17266820N8096TSchoonover Emma L · Wichita Falls, TXBuilt 1960 · S/N 17556796N80975N80975 LLC · Wilmington, DEBuilt 1976 · S/N 17266821N8097FBlue Sky Powers LLC N8097f LLC · Dover, DES/N U2060497N8097LPeters Aero Plus LLC · Freeland, MIBuilt 1967 · S/N 17256297N8097XKublank Nathan S · Sun Prairie, WIBuilt 1961 · S/N 17248597N80982Reiselt Paul T F · Corinth, MSBuilt 1976 · S/N 17266825N80985Mullins James C · Franklin, TNBuilt 1976 · S/N 17266826N8098AGann Clifton T · Guthrie, OKBuilt 1952 · S/N 20950N8098ERegistered aircraftN-number assigned, not yet registeredS/N 17272140N8098LJordan James R Trustee · Hermon, MEBuilt 1967 · S/N 17256298N8098XRaphael Christopher M · Colorado Springs, COBuilt 1961 · S/N 17248598N80991Flowers Robert Clyde III · Manchaca, TXBuilt 1976 · S/N 17266830N80996Halley Dan R · Avery, TXBuilt 1976 · S/N 17266832N8099BKlosterman Aviation LLC · Celina, OHBuilt 1957 · S/N 29899N8099LMateaki Koreen · Anchorage, AKS/N 17256299N809BTLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267437N809CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281222
Back to AD 79-10-14 R1