AD 79-08-06

Registered aircraft · 5,263

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-08-06')
    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-08-06')
  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.

N15171Eckler David L · New Hudson, MIBuilt 1972 · S/N 28-7310018N15177Air Craft Enviromental Sys Inc · Hilton, NYBuilt 1972 · S/N 28-7310019N15200Cash Warren A · Loveland, COBuilt 1972 · S/N 28-7310020N15201Quaintance Kemper A · Culpeper, VABuilt 1972 · S/N 28-7310021N15208Colorado Northwestern Community College · Rangely, COBuilt 1972 · S/N 28-7310022N15219Shoup Michael D · Pierre, SDBuilt 1972 · S/N 28-7310024N15227Plank James M · Sarasota, FLBuilt 1972 · S/N 28-7310025N15251Thompson Roger C · Herndon, VABuilt 1972 · S/N 28-7310027N15265M & P Aviation LLC · Franksville, WIBuilt 1972 · S/N 28-7310028N15266Plane Rents LLC · South Shore, SDBuilt 1972 · S/N 28-7310029N15277Flying Broom LLC · Prescott Valley, AZBuilt 1972 · S/N 28-7310030N15291Plante Victor I · Maynard, MNBuilt 1972 · S/N 28-7310031N15304Smeltzer And Sons Inc · Cape May C H, NJBuilt 1972 · S/N 28-7310032N15355Brandvold Larry J · Fairfield, MTBuilt 1972 · S/N 28-7310037N15358Daffer Jon T · Edgewood, NMBuilt 1972 · S/N 28-7310038N15363Creativity Before Capital LLC · Tampa, FLBuilt 1972 · S/N 28-7310039N15383Nevill Donald L · Clare, MIBuilt 1972 · S/N 32-7300006N15396Nomann Arnold H · Viroqua, WIBuilt 1972 · S/N 28-7310041N15397Boisvert Thomas Michael · Sonoita, AZBuilt 1972 · S/N 28-7310042N15410Simpson Randal L · Missouri City, TXBuilt 1972 · S/N 28-7310043N1541CSwan Russell · Glenside, PABuilt 1963 · S/N 28-10042N15442Buchanan Ethan D · Au Gres, MIBuilt 1972 · S/N 28-7310046N15475Ortega Chris A · Santa Fe, NMBuilt 1972 · S/N 28-7310048N15476Lengacher Caleb Lee · Montezuma, GABuilt 1972 · S/N 32-7300008N15493Midwest Flying Service Inc · Elgin, NEBuilt 1972 · S/N 28-7310050N15526Reynolds David K · Bastrop, LABuilt 1972 · S/N 28-7310052N15537J & J Aviation LLC · Thedford, NEBuilt 1972 · S/N 28-7310053N15538Schwartz David · Lakeland, FLBuilt 1972 · S/N 32-7300009N15551Buchanan Jennings R · Cocoa Beach, FLBuilt 1972 · S/N 32-7300010N15564Santi Cali Aviation LLC · Longwood, FLBuilt 1972 · S/N 28-7310056N155CTOutsideloop LLC · Denver, COBuilt 1979 · S/N R18201277N15601Wisconsin Fox River Flyers · Milwaukee, WIBuilt 1972 · S/N 28-7310059N15612Bonnette William A · Gill, MABuilt 1972 · S/N 28-7310060N15624Ultimax Inc · Columbus, OHBuilt 1972 · S/N 28-7310061N15645Ripken Robert L · Stockton, CABuilt 1972 · S/N 28-7310063N15646Smith Michael S · Norman, OKBuilt 1972 · S/N 32-7300012N15655French Creek Holdings LLC · Saratoga, WYBuilt 1972 · S/N 28-7310064N15666Miller Michelle · Las Vegas, NVBuilt 1972 · S/N 28-7310065N156DCEaton Billy J · Bridgeport, TXBuilt 1961 · S/N 24-2751N156DSFanoe Nicholas J · Salinas, CABuilt 2000 · S/N 23064CN15707Brennan Christopher S · Newark, DEBuilt 1972 · S/N 28-7310069N15735235 Aviation LLC · New Smyrna Beach, FLS/N 28-7310071N15788Chafin Gerald III · Mountain Home, ARS/N 32-7300016N1579XBuchberger Robert J · Plainfield, WIBuilt 1975 · S/N 28-7510111N157RJTdt Ag Support LLC · Brawley, CABuilt 1979 · S/N 28-7911168N15884Fredrickson Ronald C · Woodlake, CABuilt 1972 · S/N 28-7310072N1588XMilligan Reid · Catawba, NCBuilt 1975 · S/N 28-7510087N15901Harbor Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7310073N15939Ray H Gregg · Nashville, GABuilt 1973 · S/N 32-7300021N15961Kings Wings · Jupiter, FLBuilt 1973 · S/N 32-7300022
Back to AD 79-08-06