OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N3421USchuster Timothy A · Carrington, NDBuilt 1963 · S/N 18254821N3421VNebbia Valter Della · Archer City, TXBuilt 1974 · S/N 15076498N3422Hergenrather Michael · Spring, TXS/N U20602920N34221Baxter Jonathan · Centerville, MABuilt 1976 · S/N 177RG0985N34223Strother Brenda J · Kenai, AKBuilt 1972 · S/N 17701715N34225Dexter Paul J · Orange, MABuilt 1972 · S/N 17701717N34226Blasjo Darrell W · Hesperia, CAS/N 177RG0986N34227Neiser David R · Napavine, WABuilt 1972 · S/N 17701719N34228Thomas Andrew J · Brownsburg, INBuilt 1972 · S/N 17701720N34229Winchester Creek Aviation LLC · Waynesville, NCBuilt 1972 · S/N 17701721N3422CEversoll Dennis D · Petersburg, INS/N 26465N3422JRoberts Stephen L · Belmont, MIBuilt 1967 · S/N 15066122N3422LAwsm Inc · Grand Canyon, AZBuilt 1967 · S/N U206-0722N3422SLanders James F Jr · Mesa, AZBuilt 1964 · S/N 18255822N3422TMangon Ronald A · Petaluma, CABuilt 1967 · S/N 17700722N3422UK & M Aircraft LLC · Granbury, TXBuilt 1963 · S/N 18254822N3422YMoll Kenneth R · Willow, AKS/N 18051922N34231Anderson Roger Q · Manassas, VABuilt 1972 · S/N 17701723N34232Nowacki James R · Brighton, MIBuilt 1972 · S/N 17701724N34233Stimpson Shawn S · Blackfoot, IDS/N 17701725N34235Nefc Inc · North Andover, MABuilt 1972 · S/N 17701726N3423SSchroeder Matt T · Riverside, CABuilt 1964 · S/N 18255823N3423TCardinal Aviation LLC · Springdale, ARBuilt 1967 · S/N 17700723N34241Lewis Mark · Ellisville, MOS/N 17701728N34242Cherokee Pilots LLC · Royersford, PABuilt 1972 · S/N 17701729N34244Eliel F John · Sequim, WABuilt 1972 · S/N 17701731N34248Lucia Arthur H · Blacksburg, VABuilt 1972 · S/N 17701732N3424CHarris Wayne H · Altamont, TNBuilt 1972 · S/N 17701727N3424JBaird Gary H · Bracey, VABuilt 1967 · S/N 15066124N3424RMulder Field Inc · Ivanhoe, MNS/N 18258724N3424SPickering Heavy Hauling · Fort Lupton, COBuilt 1964 · S/N 18255824N3424TWiggains David · Canyon, TXBuilt 1968 · S/N 17700724N3424VDriscoll Christopher · Beaufort, SCBuilt 1974 · S/N 15076499N34250Sierra Lima Aviation LLC · Riverton, UTBuilt 1972 · S/N 17701734N34258Urias Alejandro R · Mcallen, TXBuilt 1972 · S/N 17701737N34259Sharp Kenneth M · Pueblo, COBuilt 1972 · S/N 17701738N3425CBowen Justin M · Livermore, CABuilt 1954 · S/N 26468N3425FJ A White & Son Aviation LLC · Powder Springs, GABuilt 1966 · S/N 18257425N3425JSanders Robert · Harlingen, TXBuilt 1967 · S/N 15066125N3425SHoulihan John D · Wasco, CABuilt 1964 · S/N 18255825N3425U4appraisals LLC · Odessa, TXS/N 18254825N34260Swartz Richard C · White Hall, ARBuilt 1959 · S/N 619N34264Aikens George A · Greeley, COBuilt 1959 · S/N 625N34265Clc Aviation LLC · Springfield, MOS/N 17701739N34268White James D · Bozeman, MTBuilt 1959 · S/N 628N3426ACarter Aaron T · Kasilof, AKBuilt 1961 · S/N 17248953N3426DGaither Timothy · Inman, KSBuilt 1974 · S/N 17264275N3426EJts Management Inc · Lincoln, NEBuilt 1978 · S/N 17271543N3426LCurtis Jeremy A · Fairbanks, AKBuilt 1966 · S/N U206-0726N3426YMachnik Todd J · Old Lyme, CTBuilt 1968 · S/N 18051926
Back to AD 79-10-14 R1