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.

N71298Belanger Patrick J Trustee · Gilroy, CAFirst renewal noticeBuilt 1969 · S/N 18259567N7129FDavis Clint H · Paola, KSBuilt 1966 · S/N 15063729N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429N712DAlpha Aviation LLC · Dalhart, TXBuilt 1976 · S/N 17268279N712EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12882N712JFN712jf LLC · Laveen, AZBuilt 1968 · S/N 337-0859N712LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 172S11659N712MSNational Aircraft Leasing · Greenville, DEBuilt 2009 · S/N 18282179N712NVEpic Aviation Enterprises LLC · Austin, TXBuilt 2005 · S/N 172S9960N712SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2000 · S/N 172S8640N712TCTeasdale Gregg N · Genesee, IDBuilt 1967 · S/N 18258086N712TTAb Cessna LLC · Wilmington, NCBuilt 1981 · S/N 17275235N712VAwf Aviation LLC · Calera, OKBuilt 1974 · S/N 18263162N712VTMiddle Fork Aviation Inc · Challis, IDBuilt 1967 · S/N U206-0932N71300Finch Merry B · Marysville, CABuilt 1969 · S/N 18259568N71305Fisher Vincent E · Burrton, KSBuilt 1969 · S/N 18259570N7130AJohnston David E · Fort Myers, FLBuilt 1956 · S/N 29230N7130FRicker Gary L · Greeneville, TNS/N 15063730N7130SHansen Christopher H · Durhamville, NYBuilt 1967 · S/N 15067830N71317Abbatiello Vincent Jr · Cape Coral, FLBuilt 1969 · S/N 18259575N7131AOneill Mark B · Pinckney, MIBuilt 1956 · S/N 29231N7131ETravis Michael James · Burns, ORS/N 52131N7131FSchoch Brayden · Fort Pierce, FLBuilt 1966 · S/N 15063731N7131TReyes Jose Daniel Cruz · Wilmington, NCBuilt 1959 · S/N 46731N7131XEaa Charter 1093 · Midland, MIS/N 15059231N71320Wptd Inc · Munster, INBuilt 1969 · S/N 18259577N71321Boyle Christopher R · Truckee, CABuilt 1969 · S/N 18259578N71323Air Legacy LLC · Chanhassen, MNBuilt 1969 · S/N 18259579N71326Lrc Aero LLC · Jacksonville, TXS/N 18259580N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432N71331Baird David W · Kanab, UTBuilt 1969 · S/N 18259582N71333Delaney Michael T · Edmonds, WABuilt 1969 · S/N 18259583N71336Aviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1969 · S/N 18259585N7133APeacock Richelle L · Arcadia, FLBuilt 1956 · S/N 29233N7133FCarrolls Auto And Aircraft Sales LLC · Muncie, INBuilt 1966 · S/N 15063733N7133QPage Aerial Service Inc · Rochelle, ILBuilt 1972 · S/N 17260433N7133TQuam Gary L · Rio, WIBuilt 1959 · S/N 46733N7134FMejean Kenneth R · Brandon, FLBuilt 1966 · S/N 15063734N7134MTravis Craig W · Fallon, NVBuilt 1958 · S/N 55434N71354Willis Enterprises · Enterprise, ORBuilt 1969 · S/N 18259589N71355Dal Tex Flyers Inc · Arlington, TXBuilt 1969 · S/N 18259590N71359Sparks Fly LLC · Mount Gilead, OHBuilt 1969 · S/N 18259593N7135AMoss Colin · Sparta, NCBuilt 1956 · S/N 29235N7135FMiller Joseph A · Amissville, VABuilt 1966 · S/N 15063735N7135QHoman Larry E · Sigourney, IABuilt 1972 · S/N 17260435N71369Gosney James R Trustee · Silver City, NMBuilt 1969 · S/N 18259595N7136ACross Frank · Huntsville, MOBuilt 1956 · S/N 29236N7136ECreel Jeffrey G · Gaylesville, ALBuilt 1959 · S/N 52136N7136GFairchild Natalie J · Drummond Island, MIS/N 15074614
Back to AD 79-10-14 R1