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.

N6505GStern Scot G · Escondido, CABuilt 1970 · S/N 15072005N6505N3c3 Aviation Inc · Dania Beach, FLBuilt 1979 · S/N 21063075N65065Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275681N6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTBuilt 1979 · S/N 17272835N6506EArmstrong Bruce · Port Orchard, WABuilt 1959 · S/N 56006N6506FMdowell Pilot Service LLC · South Hutchinson, KSS/N 15063106N6506GWestern Skyways Inc · Montrose, COS/N 21064406N6506MBeechhurst Corp · Wilmington, DEBuilt 1975 · S/N 18263735N6506VHarper Dreams LLC · New Smyrna Beach, FLBuilt 1976 · S/N 21061633N6506XBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57506N6506ZAf Auto Group · San Jose, CABuilt 1981 · S/N U20606301N6507XBailey Scott D · Ione, CABuilt 1960 · S/N 57507N6508HBkb Inc · Newport, MIBuilt 1975 · S/N 17265469N6508KTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274205N6508TManchester Eric S · Milton, VTBuilt 1960 · S/N 17908N65093Seaman Michael V · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 21061844N6509GMehling Robert C · Hardin, MTS/N 18801202N6509HSale Reported · Benton, KSSale reportedBuilt 1975 · S/N 17265470N650VVMindy Limited LLC · Muscatine, IABuilt 1969 · S/N 17258561N65107Renforth Michael E · Yorktown, VABuilt 1982 · S/N 17275686N6510EScherer Luis R · Kent, OHBuilt 1959 · S/N 56010N6510FPrice Gregory L · Kyle, TXBuilt 1966 · S/N 15063110N6510XSteinbroner Daniel J · Lawton, OKBuilt 1960 · S/N 57510N65112Jav Air Services LLC · Anchorage, AKS/N 17275688N6511EMckenna Francis · Granville, PABuilt 1959 · S/N 56011N6511GBuerk James R · Smethport, PABuilt 1979 · S/N 17273603N6511SGby Aero LLC · Cocoa, FLS/N 15067311N6511VSc Skywalker Aviation LLC · West Sacramento, CABuilt 1980 · S/N 172RG0741N6512DCajun Wings LLC · Bourg, LABuilt 1979 · S/N 17272836N6512GParry Anthony D · Sedro Woolley, WAS/N 15072012N6512HOrganization Of Black Aerospace Professionals Inc · Olive Branch, MSBuilt 1975 · S/N 17265471N6512KLoomis Aviation LLC · Columbus, OHBuilt 1980 · S/N 17274206N6512SHaskin Jeff · Sulphur Springs, TXBuilt 1967 · S/N 15067312N6512TJestes Monte G · Stillwater, OKS/N 17912N6513DGhia Flying Venture LLC · Scottsdale, AZBuilt 1979 · S/N 17272837N6514JJuggernautaviation LLC · Lewes, DEBuilt 1980 · S/N 17273880N6515GNorthwest Aeroventures LLC · Steilacoom, WABuilt 1970 · S/N 15072015N6515SMoroney Richard D · Mc Grath, MNS/N 15067315N6515XDauenhauer Steven M · Springtown, TXFirst renewal noticeBuilt 1960 · S/N 57515N6516SLee Robert E · Medford, WIS/N 15067316N6516TMiller Shawn C · Milaca, MNBuilt 1960 · S/N 17916N65172Kfam Enterprises LLC · Dover, DES/N 17252998N6517APeterson Holding Co · San Leandro, CABuilt 1979 · S/N 21063541N6517DSlaboszewski Donald W Jr · Joliet, ILS/N 17272839N6517ERed Baron LLC · Middletown, DES/N 56017N6517FSnouffer Robert E · Mountain Grove, MOBuilt 1966 · S/N 15063117N65180Mccraw Bryan · Telephone, TXBuilt 1982 · S/N 17275702N6518EMozingo James C · Hernando, FLBuilt 1959 · S/N 56018N6518TMcclintock Matthew · Oscoda, MIS/N 17918N65191Bampton Dennis · Portage Des Sioux, MOBuilt 1982 · S/N 17275705
Back to AD 79-10-14 R1