OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N2628DN2628d LLC · Cheyenne, WYBuilt 1956 · S/N 20780N2628FPlata Darryl · Arlington, WABuilt 1965 · S/N 18256728N2628JGoslin Joel · Anchorage, AKBuilt 1966 · S/N 15065628N2628LBerg C Aaron · Driscoll, NDS/N 17255828N2628QSannikova Olga · Sherman Oaks, CAS/N 18257828N2628SSpencer Bennett E · Cleburne, TXBuilt 1968 · S/N 337-0928N2628UMiranda Jason G · Utica, OHBuilt 1963 · S/N 17250228N2629DFoss James K · Anchorage, AKS/N 20781N2629FFodness Jan N · Sioux Falls, SDBuilt 1965 · S/N 18256729N2629JMartin Jonathan W · West Grove, PABuilt 1966 · S/N 15065629N2629LHein Merilee K · Mabel, MNBuilt 1967 · S/N 17255829N2629QStallings Floyd P · Vine Grove, KYBuilt 1967 · S/N 18257829N2629VEyw Flying LLC · Key West, FLBuilt 1974 · S/N 177RG0635N2629YMayeko-Coklee Thomas · Lake Worth, FLS/N 15077311N262AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281187N262APKirk Donald D · Fairbanks, AKBuilt 1975 · S/N 18502645N262CACompass Aviation Inc · Shelby, NCBuilt 1981 · S/N U20606094N262CLGiga Energy Inc · Buna, TXBuilt 2004 · S/N 18281497N262CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283017N262DQIschi Phillip · Soldotna, AKBuilt 1978 · S/N U20604479N262EEHorizon Flights Corp · Henderson, NVBuilt 1973 · S/N 17261621N262ERRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17263854N262GSMinor Michael D · Grove City, PAS/N 18265183N262MGordon Bruce · Marstons Mills, MABuilt 1976 · S/N 17268356N262MTBurns Mark R · Streetsboro, OHBuilt 2016 · S/N 18282449N2630GMarvil Sean · El Prado, NMS/N 51930N2630MMock Air LLC · Marion, INBuilt 1979 · S/N 17271166N2630QParrington Robert · Rifle, COS/N 18257830N2630RBurdine Kenneth L · Newland, NCS/N 18258330N2630SDuquette Stephen R · Fenton, MIBuilt 1968 · S/N 337-0930N2630UShaka Skies LLC · Kihei, HIBuilt 1998 · S/N 17280568N2630VAgue Curtis M · Kailua, HIBuilt 1974 · S/N 177RG0636N2630XBbjc Adventures LLC · Jackson, WIBuilt 1965 · S/N P206-0130N2631DHumphreys Grant R · Anchorage, AKBuilt 1952 · S/N 20783N2631FShepherd Thomas A · Montgomery, NYFirst renewal noticeBuilt 1965 · S/N 18256731N2631GMac Neil David M · Clarkston, WABuilt 1959 · S/N 51931N2631QManning Brian A · Malvern, IABuilt 1966 · S/N 18257831N2632DRech Timothy J · Camano Island, WAS/N 20784N2632FOn Final Holdings LLC · West Olive, MIBuilt 1965 · S/N 18256732N2632GHuey James M · Fulton, MOFirst renewal noticeBuilt 1959 · S/N 51932N2632LKelley James M · Greenwood, ARBuilt 1967 · S/N 17255832N2632SAvialogia Inc · Wilmington, DES/N 337-0932N2632YAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280570N2633FYork Greg · Blanco, TXBuilt 1965 · S/N 18256733N2633RDevries Mark R · Eagle River, AKBuilt 1967 · S/N 18258333N2633SAir Apparent LLC · Santa Rosa, CAFirst renewal noticeBuilt 1968 · S/N 337-0933N2634EAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280572N2634FCockerham Milton D · Gooding, IDBuilt 1965 · S/N 18256734N2634JCupka Michael J · North Waterboro, MEBuilt 1966 · S/N 15065634N2634LMetal Mistress Aviation LLC · Meadowview, VABuilt 1967 · S/N 17255834
Back to AD 79-10-14 R1