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.

N3441FLawrence Kam M · Big Bear City, CABuilt 1966 · S/N 18257441N3441LBarlow Dwight D · Monte Vista, COBuilt 1966 · S/N U206-0741N3441RQualtieri John E · Fallon, NVS/N 18258741N3441SSun Technology LLC · Cheyenne, WYBuilt 1964 · S/N 18255841N3441UDemeyer Scott M · Olympia, WABuilt 1963 · S/N 18254841N3441YBird Avery L · Wasilla, AKBuilt 1968 · S/N 18051941N34420Berman John L · Corvallis, ORS/N 17701794N34426Cardinal 426 LLC · Jacksonville, FLBuilt 1976 · S/N 177RG0996N34427Cessna 177b Cardinal LLC · Prescott, AZBuilt 1972 · S/N 17701797N3442CClaire Aviation Inc · Wilmington, DEBuilt 1954 · S/N 26485N3442DLowery Chad Lewis · Palmer, AKBuilt 1955 · S/N 26985N3442EOwens John W Sr · Myrtle Beach, SCBuilt 1978 · S/N 17271548N3442SRail Birds · Clearfield, UTBuilt 1964 · S/N 18255842N34430Travland Christopher L · Austin, TXBuilt 1972 · S/N 17701798N34432Wallace James K · Rio Rancho, NMBuilt 1972 · S/N 17701799N34433Sowlemann Inc · Rockton, ILBuilt 1972 · S/N 17701800N3443CSale Reported · Mesa, AZSale reportedBuilt 1954 · S/N 26486N3443DMiller Charles T · Bynum, TXBuilt 1951 · S/N 20102N3443RBertrand John E · Trion, GABuilt 1967 · S/N 18258743N3443SWilliams Forest Chem LLC · Columbus, GABuilt 1964 · S/N 18255843N3443UHall George K · Cathedral City, CABuilt 1963 · S/N 18254843N3443YTurner Nathan D · Nenana, AKBuilt 1968 · S/N 18051943N34442Valenti Alan · Bend, ORBuilt 1972 · S/N 17701805N34443Schwitters Jerry · Clara City, MNS/N 17701806N34444Lil Red Cardinal LLC · Phoenix, AZBuilt 1972 · S/N 17701807N34445East Carolina Aviation LLC · Camden, NCBuilt 1972 · S/N 17701808N34448Schleicher Conan A · Salem, ORBuilt 1972 · S/N 17701809N3444CRichards Chad M · North Pole, AKS/N 26487N3444DBaker Adam J · Eaton Rapids, MIS/N 26987N3444FAtwood David E Trustee · Nampa, IDBuilt 1966 · S/N 18257444N3444LDierick Greg E · Yakutat, AKS/N U206-0744N3444SBraha Thomas I · Mansfield, PABuilt 1964 · S/N 18255844N3444THunter David Frederick · Peachtree City, GABuilt 1968 · S/N 17700744N3444ULepton Films LLC · Tarzana, CABuilt 1963 · S/N 18254844N3444YParish John L Jr · Saint Louis, MOBuilt 1975 · S/N 18502879N34453Porcaro James · Latham, NYS/N 17701814N3445EHicks Robert C · Atkins, VABuilt 1978 · S/N 17271551N3445FAltus Aircraft LLC · Taylor, TXBuilt 1966 · S/N 18257445N3445LYama Air LLC · Granite Bay, CABuilt 1966 · S/N U206-0745N3445SBigfoot Aviation LLC · Shelton, WAS/N 18255845N3445TNelson Stephen A · Milaca, MNBuilt 1968 · S/N 17700745N34464Morgan Michael B · Stanwood, WAFirst renewal noticeBuilt 1972 · S/N 17701821N34465Brodbeck William J · Kyle, TXBuilt 1972 · S/N 17701822N34467Drust Joseph L · Menominee, MIBuilt 1972 · S/N 17701824N34469Kroll Richard L · Kalamazoo, MIBuilt 1972 · S/N 17701826N3446CGillaspie Terry H · Huntsville, TXS/N 26489N3446TR & B Air LLC · Clayton, MOBuilt 1968 · S/N 17700746N3446UTempus Morgan C · Cameron Park, CABuilt 1963 · S/N 18254846N34471Grass Dennis Lee Trustee · Grass Valley, CABuilt 1972 · S/N 17701827N3447FEngh David Trustee · Wickenburg, AZBuilt 1966 · S/N 18257447
Back to AD 79-10-14 R1