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.

N812FPeter Kevin · Hermon, MEBuilt 1977 · S/N 18503277N812KKKerscher Helen A · Los Lunas, NMBuilt 1974 · S/N 18262759N812KRSchneider Richard A · Ellicott City, MDBuilt 1978 · S/N 18266016N812KSUniversity Of Central Missouri · Warrensburg, MOBuilt 2005 · S/N 17281246N812MCFly Bye Air LLC · Southport, NCBuilt 2003 · S/N 18281208N812PLCirrusair LLC · Missoula, MTBuilt 1975 · S/N 18263781N812THSuss Charles H · Woodford, VTBuilt 1971 · S/N 17701615N812WJjc Enterprises Inc · Dillingham, AKBuilt 1975 · S/N U20602770N8130BJohnson Daniel P · Pardeeville, WIBuilt 1957 · S/N 29930N8130GBank Of Utah Trustee · Salt Lake City, UTBuilt 1973 · S/N 18801243TN8130LPerfect 10 Roofing · Billings, MTS/N 21060617N8130TMoore Dallas L · Rotonda, FLRegistration revokedBuilt 1960 · S/N 17556830N8130UWade Air LLC · Clanton, ALBuilt 1964 · S/N 17252030N8130ZChalmers Russell P · Saint Martinville, LABuilt 1962 · S/N 205-0130N8131GTalley Edward P · San Jose, CABuilt 1971 · S/N 21059431N8131LGerber Aviation LLC · Winter Haven, FLBuilt 1971 · S/N 15072534N8131UTodd James M · Angleton, TXBuilt 1964 · S/N 17252031N8132AProell Eric R · Fairbanks, AKBuilt 1952 · S/N 20984N8132SHarris Gregory A · Aurora, COBuilt 1965 · S/N 15061732N8132TSlade Richard · Halifax, PABuilt 1960 · S/N 17556832N8132ZCrown L Inc · Greenacres, FLBuilt 1962 · S/N 205-0132N8133BReaka Dean James Trustee · Troy, MOBuilt 1957 · S/N 29933N8133FMagarian Mitchell · Jacksonville, FLBuilt 1966 · S/N 15064233N8133UDunaire LLC · Mechanicsburg, PAS/N 15077897N8133XAdamie Isaac Sloan · Bowling Green, KYBuilt 1961 · S/N 17248633N8134BTreefo Bravo LLC · Hawkins, TXS/N 29934N8134FHammond Steven R · Trenton, MOBuilt 1966 · S/N 15064234N8134UColey Lee · Fayetteville, GABuilt 1964 · S/N 17252034N8134XLugas Grant A · Elyria, OHBuilt 1961 · S/N 17248634N8135SMcjunkin John Michael · Portland, ORRegistration revokedBuilt 1965 · S/N 15061735N8135XMatarelli Robert E Jr · Carlton, MNBuilt 1961 · S/N 17248635N8136ARedman Thomas F · Talkeetna, AKBuilt 1952 · S/N 20988N8136BStanley Mark E · Paso Robles, CABuilt 1957 · S/N 29936N8136FRawson Aviation LLC · Ardmore, OKBuilt 1966 · S/N 15064236N8136MTakeair LLC · Incline Village, NVBuilt 1976 · S/N 18264546N8136SPockrus Pat B · Mineral Wells, TXS/N 15061736N8136UMoors Thomas G · Wentzville, MOBuilt 1964 · S/N 17252036N8136XStevenson George Otis · Wheatland, WYBuilt 1961 · S/N 17248636N8137BKelly James E · Accord, NYBuilt 1957 · S/N 29937N8137GTwo Ten K LLC · Upper Sandusky, OHBuilt 1971 · S/N 21059437N8137LShreve Jerry · Warrensburg, MOBuilt 1974 · S/N 21060624N8137XHarritt Roger · Anchorage, AKBuilt 1961 · S/N 17248637N8137ZSullivan Harry Stuard Trustee · Banning, CABuilt 1962 · S/N 205-0137N8138ANelson Richard W · Edna, TXBuilt 1952 · S/N 20990N8138GRab Com Limited · Hayward, CABuilt 1971 · S/N 21059438N8138QAnderson Marshall H · Anchorage, AKBuilt 1978 · S/N 18503633N8138TSvoboda Patrick J · Bucyrus, KSBuilt 1960 · S/N 17556838N8138UBurner Dwight L · Mc Gaheysville, VABuilt 1976 · S/N 15077899N8138XHarris David L · Wichita, KSFirst renewal noticeBuilt 1961 · S/N 17248638N8139BDavies Lincoln J · Oostburg, WIBuilt 1957 · S/N 29939
Back to AD 79-10-14 R1