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.

N6100YRamsay Allan Trustee · Modesto, CABuilt 1981 · S/N 21064250N61010Hall Scotty · Cheraw, SCBuilt 1969 · S/N 15070731N61019Goodwin William J · Charlotte C H, VAS/N 15070738N6101BRegistered aircraftS/N 34101N6101EScherer Dean W · Saint Joseph, MNS/N 46201N61020Houk Sean R · Lyons, OHBuilt 1969 · S/N 15070739N61025Registered aircraftBuilt 1980 · S/N 18504098N61026Johnson David A · Dover, OHBuilt 1969 · S/N 15070744N61028Berendes Jay R · Shullsburg, WIBuilt 1969 · S/N 15070746N6102RAerospace Aviation Services Inc · Wilmington, DEBuilt 1979 · S/N 172RG0084N61030Balderrama Arturo · Mcminnville, ORBuilt 1969 · S/N 15070748N61031Pacific Aircraft Services · Aurora, ORBuilt 1969 · S/N 15070749N61033Dame John D · Omaha, NEBuilt 1969 · S/N 15070751N61038Bartholomew Howard R Jr · Mechanicsburg, PABuilt 1969 · S/N 15070755N6103ERadloff Adam E · Delaware, OHBuilt 1958 · S/N 46203N6103NRed Leasing LLC · Juneau, AKS/N 20700194N6103RAta Auto Service Inc · Wilmington, NCBuilt 1965 · S/N T210-0003N61041Pattison Aero Inc · Upland, CABuilt 1969 · S/N 15070758N6104ULavy Brothers Farming · Biggs, CAS/N 21064901N61051Crispin Michael J · Broadalbin, NYBuilt 1969 · S/N 15070765N61052Secker-Walker Hugh E · Newburyport, MAS/N 15070766N61055Booher Tabitha O · Livingston, TNBuilt 1969 · S/N 15070768N61057Provenzano Jeremy E · Aurora, COBuilt 1969 · S/N 15070770N6105FShaw Christopher S · Porterville, CABuilt 1968 · S/N 21059005N6105VSchlesinger Henry R · Castalian Springs, TNBuilt 1980 · S/N 172RG0580N61061Townsend John J · Valliant, OKBuilt 1969 · S/N 15070773N61062Bate David F · Vanceburg, KYBuilt 1969 · S/N 15070774N61064N61064 LLC · Forest Park, ILBuilt 1969 · S/N 15070775N61067Connolly Luile A · Blaine, MNBuilt 1969 · S/N 15070777N6106BBeck Brooks R · Spearman, TXBuilt 1957 · S/N 34106N6106EBaer Mack III · Marshall, VABuilt 1958 · S/N 46206N61075Evan R Charles · Riverside, CAS/N 15070780N61077Ray Albert B · Prosser, WAS/N 15070782N61078Registered aircraftBuilt 1969 · S/N 15070783N6107EDelta-V Ceramic Technologies Inc · San Jose, CAS/N 18268345N6107GRhea Koy A · Annona, TXBuilt 1969 · S/N 15071607N61081Beattie Mark A · Anaheim, CABuilt 1969 · S/N 15070784N6108BBuchner George E · Nye, MTBuilt 1957 · S/N 34108N6108GPetrov Konstantin P · Hallandale, FLBuilt 1969 · S/N 15071608N6108TKidd Matthew D · Huddleston, VAS/N 15060808N61091O'Flynn Brian · Mimbres, NMBuilt 1969 · S/N 15070794N61092Registration Pending · Cadillac, MIRegistration pendingBuilt 1980 · S/N 18504107N61094Harper Kevin J · Valley Center, KSBuilt 1969 · S/N 15070795N61097Giles David Victor · Gilbert, AZBuilt 1969 · S/N 15070798N6109BTony Flies Inc · Sparta, NCBuilt 1957 · S/N 34109N6109ELucia Christoper J · West Brookfield, MABuilt 1958 · S/N 46209N6109KRiegel Frederick E · Houston, OHBuilt 1975 · S/N 15077530N6109RBas Part Sales LLC · Greeley, COBuilt 1965 · S/N T210-0009N610ACHybird Inc · Corpus Christi, TXS/N 17264912N610AGObr Leasing · Bristow, VAFirst renewal noticeBuilt 2010 · S/N 20608324
Back to AD 79-10-14 R1