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.

N5927ASamaritans Purse · Boone, NCS/N 28527N5927BEmerson Christopher D · Mount Pleasant, ARS/N 33927N5927RRodrigues Robert R · Cordova, AKS/N 17253596N59286Staley Ronald L · Lebanon, ORBuilt 1974 · S/N U20602643N5928AToribio LLC · San Antonio, TXBuilt 1956 · S/N 28528N5928BSteinhausen Darrell · Torrington, WYBuilt 1956 · S/N 33928N5928EGace Flying Club Inc · Ronkonkoma, NYBuilt 1978 · S/N 17271964N5928FKerr Daniel · Bakersfield, CABuilt 1967 · S/N 21058928N5928JParsons Royson A · Atascadero, CABuilt 1971 · S/N A1500228N59292Cloud Busters LLC · Goodrich, MIBuilt 1974 · S/N 21060196N59294Cornucopia Investment Group LLC · South Jordan, UTBuilt 1974 · S/N U20602645N59299Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 21060199N5929BRegistered aircraftBuilt 1956 · S/N 33929N5929EAnderson Raymond O · Bismarck, NDBuilt 1959 · S/N 17429N5929TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 2002 · S/N 17281105N592CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12731N592HPAeroquest LLC · Olive Branch, MSBuilt 1973 · S/N 15075451N592JSStraut James M · Upper Saddle River, NJS/N 18281041N592KBCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601770N592PCFlanagan Geri M · Bandon, ORS/N 15076027N5930AUthe Wendy G · Wellsville, MOBuilt 1956 · S/N 28530N5930FCable Strong Aircraft Holdings LLC · Tyler, TXS/N 21058930N5930RDownwind Corp · Brush Prairie, WAS/N 17253599N5931GOconnor Mary B · Anchorage, AKBuilt 1969 · S/N 15071431N5931TFreitas Durval S · Tulare, CABuilt 1964 · S/N 15060631N59327Smith Steve W · Mackay, IDBuilt 1966 · S/N 337-0373N5932AAquila Aviation LLC · Pompano Beach, FLBuilt 1956 · S/N 28532N5932BAbsolute Altitude LLC · Buena Vista, COBuilt 1956 · S/N 33932N5932ELockwood Shawn O · Volborg, MTBuilt 1959 · S/N 17432N5932GBergen Henry E · Fond Du Lac, WIS/N 15071432N5932JOwen Stephen M · Wiggins, MSBuilt 1975 · S/N 18263583N5932TSmith Jason M · Holland, PABuilt 1964 · S/N 15060632N5933AWicklander Richard O · Spanaway, WABuilt 1956 · S/N 28533N5933BManier Byron K · Houston, MOBuilt 1956 · S/N 33933N5933EForsha Scott A · Cypress, TXBuilt 1959 · S/N 17433N5934AJenkins Brian T · Batesville, INBuilt 1956 · S/N 28534N5934BLlk Aviaiton LLC · Hanksville, UTS/N 33934N5934GDevils Lake Aero Repair Inc · Devils Lake, NDS/N 15071434N5934RHoyt Jacob T · Oneida, NYS/N 17253603N5935ADunn James Blair Jr · Bumpass, VABuilt 1956 · S/N 28535N5935GDeaero LLC · Darwin, MNBuilt 1968 · S/N 15071435N5935JSwinden Jonathan · Danville, PABuilt 1975 · S/N 18263585N5935RStofer William B · Warsaw, INBuilt 1965 · S/N 17253604N5935TValley Wings Flight School LLC · Harlingen, TXBuilt 1964 · S/N 15060635N5936BTorrison Scott D · Chugiak, AKBuilt 1956 · S/N 33936N5936EJensenius Danial P · Ray Twp, MIBuilt 1959 · S/N 17436N5937FDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 21058937N5937GD'Arge Ranyon Wc · Wilson, WYBuilt 1969 · S/N 15071437N5937RDavies Shane E · Kent, WAS/N 17253606N5938ALand-O-Matics LLC · Wilmington, DEBuilt 1956 · S/N 28538
Back to AD 79-10-14 R1