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.

N55422Boardman Thomas M · Greenwich, NYS/N 17275178N5542BSkydive Coolidge Inc · Tempe, AZBuilt 1956 · S/N 33542N5542CPatterson Phillip L · Knoxville, TNBuilt 1950 · S/N 19818N5542NRegistration Pending · Denver, CORegistration pendingBuilt 1980 · S/N 18267781N5543ASelf Defense Of New England LLC DBA · Bedford, NHBuilt 1956 · S/N 32660N5543BSvetlik Ludvik J · Victoria, TXBuilt 1956 · S/N 33543N5543CScott Benge D · Lebanon, ORS/N 19819N5543EMedina Kevin S · Glendale, CABuilt 1978 · S/N 17271886N5544CSamoilenko Sergey V · Hillsborough, NCBuilt 1950 · S/N 19820N5544NSkydive Co · Fairburn, GAS/N 18267782N5544RDijon Aviation LLC · Wadsworth, ILBuilt 1965 · S/N 17253129N55457Legend Air Lease LLC · Hurricane, UTBuilt 1981 · S/N 17275184N5545CJenkins Alfred G · Bangor, MEBuilt 1950 · S/N 19598N5545GTinkham Dennis T · Leavenworth, KSBuilt 1969 · S/N 15071045N5545RCarlson Michael · Burlington, WYBuilt 1965 · S/N 17253130N5546BHeczko Eric M · Longmont, COBuilt 1956 · S/N 33546N5546CWeinant Michael W Trustee · Fairbanks, AKBuilt 1950 · S/N 19599N5546ERosenthal John S · Bishop, CABuilt 1958 · S/N 17046N5546JRegistration Pending · Danbury, CTRegistration pendingS/N 17273816N5546RGorn Joel · Lawrence, MABuilt 1979 · S/N 172RG0075N5546TMeigs Craig · Jasper, ALS/N 17251446N5547ESissom Patrick · Hillsboro, TNBuilt 1958 · S/N 17047N5547TGoodyear Ron L · Leo, INBuilt 1964 · S/N 17251447N5547VDahl Demar · Deeth, NVS/N 32054N55482Crook Mark E · Elberton, GABuilt 1981 · S/N 17275193N5548EPowell Nathan · Columbia Falls, MTS/N 17048N5548RSmietanski Nathan E · Terlton, OKBuilt 1965 · S/N 17253134N5549AGeoterra Inc · Eugene, ORBuilt 1979 · S/N 21063491N5549EBacchus Tim · Tucson, AZBuilt 1958 · S/N 17049N5549GFrantz Donna Pratt · Ocala, FLBuilt 1969 · S/N 15071049N554CTGeyer Martin J · Caro, MIBuilt 1975 · S/N 18263737N554EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12873N554TADelta Charlie Aviation LLC · Aliso Viejo, CABuilt 2003 · S/N 172S9455N554WMValdosta Flying Group LLC · Valdosta, GAFirst renewal noticeBuilt 2005 · S/N 18281666N5550BLieberherr John W · Clancy, MTS/N 33550N5550CBendickson Roger · Garrison, NDBuilt 1950 · S/N 19603N5550JOptima Aviation LLC DBA · Lewisville, TXBuilt 1980 · S/N 17273818N5550RMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253137N5550TCirrus Five LLC · Merritt, NCBuilt 1964 · S/N 17251450N5550YSteiner Paul R · Boerne, TXBuilt 1981 · S/N 21064245N55515Fly Cessna LLC · Peoria, AZBuilt 1981 · S/N 17275195N5551CAer Kelly LLC · Port Orange, FLBuilt 1950 · S/N 19604N5551TBailey Robert S · Temecula, CAS/N 17251451N55521Carter Flygare Inc · Sacramento, CABuilt 1981 · S/N 17275196N5552CMcqueary David L · Plant City, FLBuilt 1950 · S/N 19605N5552EAbove And Beyond Aviation LLC · Austin, TXS/N 17271887N5552VJust Plane Stuff Inc · Jackson, MSBuilt 1980 · S/N 172RG0570N5553EVogel Mark · North Bethesda, MDBuilt 1983 · S/N 18268331N5553TVan Kleek Steve D · Milford, IABuilt 1964 · S/N 17251453N5554RRidge Rickey S · Wortham, TXBuilt 1965 · S/N 17253142
Back to AD 79-10-14 R1