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.

N5259ECole Charles · Las Vegas, NVBuilt 1959 · S/N 50559N5259HTrifunovic Stefan · Grosse Pointe Park, MIBuilt 1975 · S/N 17265387N5259QFrantz David L · Murfreesboro, TNBuilt 1972 · S/N 15073159N5259RCarnathan Robert J · Newark, CABuilt 1974 · S/N 17263473N5259WLauff Samuel J · Ocala, FLS/N 337MO196N525AGNoland Ronald E · Weston, ORS/N 51986N525JBWalton Jack R · Granbury, TXBuilt 1979 · S/N 18503907N525JGFlycarolina LLC · Concord, NCS/N 172RG0178N525KWFuller Thomas R · Scottsdale, AZBuilt 1975 · S/N 21060881N525LRSkywalker Leasing LLC · Wilmington, DEBuilt 1980 · S/N 18267356N525NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10817N525SHMcn Systems LLC · Mount Airy, MDBuilt 1965 · S/N 15062549N525XHarvey Thomas H · Novi, MIBuilt 1963 · S/N 206-0013N525ZMMaba Aircraft Services Co · Vero Beach, FLS/N 56760N52602Hutch Aviation Inc · Zavalla, TXBuilt 1980 · S/N 17274562N52604Harding Marc S · Des Moines, IABuilt 1977 · S/N 177RG1213N52606Cirrus Aviation Inc · Sarasota, FLBuilt 2009 · S/N 172S10995N52607Jse Holdings Inc · Wilmington, DEBuilt 1973 · S/N 18262705N52608Kaliebe Kyle D · Mount Pleasant, WIBuilt 1973 · S/N 18262706N5260AN5260a LLC · Los Angeles, CAS/N 21063333N5260DMeyer Kevin · Hooper, NEBuilt 1979 · S/N 17272478N5260KPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 17274035N5260NBates Management Inc · Woodstock, GAS/N 18267609N5260RSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263474N52612Daniels Willie L II · Castle Pines, COBuilt 1977 · S/N 177RG1215N52617Land And Sky LLC · Buffalo, MNBuilt 1973 · S/N 18262715N52619Lardin William A · Thomasville, GABuilt 1977 · S/N 177RG1216N5261FTopken William F · Fallon, NVS/N 17253375N5261NCrowe Bradley Allen · North Chelmsford, MABuilt 1980 · S/N 18267610N5261UBackus Gary Carl · Chesapeake, VABuilt 1980 · S/N 172RG0308N52620High Risk Ventures Inc · San Diego, CABuilt 1973 · S/N 18262718N52621Bottieri David P · Mission Viejo, CABuilt 1973 · S/N 18262719N52624Shrewsbury Roy E II · Daniels, WVBuilt 1973 · S/N 18262721N52629Mbr Air LLC · Kenosha, WIBuilt 1973 · S/N 18262726N5262HBun Air Corp · Bedford, PABuilt 1975 · S/N 17265388N5262UL&W Aircraft Investment LLC · Homestead, FLBuilt 2002 · S/N 172S9175N5262YLead Turn Aviation LLC · Ogden, UTBuilt 2002 · S/N 172S9176N52634Beck Gary F · Cypress, TXBuilt 1977 · S/N 177RG1219N52635Allard Michael · Penrose, COS/N 17274573N52636Macdonald Russell K · Richmond Hill, GABuilt 1977 · S/N 177RG1220N5263QZahn Jason L · Towner, NDBuilt 1965 · S/N 17253380N5263VMccullough James M · Monte Vista, COBuilt 1975 · S/N 21060883N52640Crawford Bill E · Hayti, MOBuilt 1977 · S/N 177RG1224N52643Cardinalrg LLC · Ballwin, MOBuilt 1977 · S/N 177RG1225N52647Berling David · Litchfield Park, AZBuilt 1977 · S/N 177RG1229N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725N5264DPironti Bennett D · Long Valley, NJS/N 17272481N5264KRmg Aviation LLC · Newark, DEBuilt 1980 · S/N 17274036N52654Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274576N5265DFly 172rg LLC · Peoria, AZBuilt 1979 · S/N 17272482
Back to AD 79-10-14 R1