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.

N65742Mustang Sally Aviation LLC · Camden, SCS/N 17275847N65743University Of Central Missouri · Warrensburg, MOBuilt 1982 · S/N 17275848N65745Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9748N65746Son Cameron D · Groveland, FLFirst renewal noticeBuilt 1982 · S/N 17275851N6574DFly Carolina LLC · Concord, NCBuilt 1979 · S/N 17272874N6574EGoodman Bert D · Canaan, MEBuilt 1959 · S/N 56074N6574GPplforu LLC · Fort Worth, TXBuilt 1979 · S/N 17273608N6574TSan Diego Community College District · San Diego, CAS/N 17974N65750Christiansen Aviation LLC · Wilmington, DEBuilt 1982 · S/N 17275855N65752Owens Flight Training LLC · Lafayette, LABuilt 1982 · S/N 17275857N65753Flying Bulldogs LLC · Joplin, MOBuilt 1982 · S/N 17275858N65758American Patrols Inc · Midland, TXBuilt 1982 · S/N 17275862N6575AWhitmore Alex · Terlingua, TXBuilt 1956 · S/N 32472N6575EPoutre Robert P · Osceola, WIBuilt 1959 · S/N 56075N6575FBarnett Joe N · Siloam Springs, ARBuilt 1966 · S/N 15063175N6575TSetzer Theodore E · Granite Falls, WAS/N 17975N65767Chu'S Sky LLC · Brandon, FLBuilt 1982 · S/N 17275871N6576NFaaz Aircrafts LLC · Irving, TXBuilt 1981 · S/N 18267839N6576TShields Aidan J · Soldotna, AKBuilt 1960 · S/N 17976N6576XG23 Holdings LLC · Hollywood, FLBuilt 1960 · S/N 21057576N65770Thompson Clinton J · Greer, SCBuilt 1982 · S/N 17275874N65772Sky Adventure LLC · Bartlett, TNBuilt 1982 · S/N 17275875N65773Ial Corp · Lewes, DEBuilt 1982 · S/N 17275876N65775Ristrim Eric · Henderson, NVBuilt 1982 · S/N 17275878N65776Meridian Aviation Holding Company · Teterboro, NJBuilt 1982 · S/N 17275879N6577ANafus Gifford William · Palmer, AKBuilt 1956 · S/N 32474N6577HRegistered aircraftBuilt 1975 · S/N 17265496N6577RAir Echo Alpha 51 LLC · Erie, COBuilt 1979 · S/N 172RG0203N6577TRegistration Pending · Milton, DERegistration pendingBuilt 1960 · S/N 17977N65784Ohio State University · Columbus, OHBuilt 1982 · S/N 17275884N65789Burket George C · North Hollywood, CABuilt 1982 · S/N 17275888N65790Horan Peter · North Easton, MABuilt 2005 · S/N 172S9787N65795Bank Of Utah Trustee · Salt Lake City, UTS/N 172S9977N65798Samons David M · Phoenix, AZBuilt 1982 · S/N 17275894N6579ESkinner William T III · Little Rock, ARBuilt 1959 · S/N 56079N6579FPratka Rhett A · Pleasanton, TXBuilt 1966 · S/N 15063179N657CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281657N657EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2020 · S/N 172S12455N657SCKruse Shannon E · Republic, MOBuilt 1973 · S/N 177RG0301N657SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8062N657SRRm & Lp Ltd · Azalea, ORBuilt 1968 · S/N 17701019N657TPZma LLC · North Little Rock, ARBuilt 2010 · S/N 18282253N6580AHelleloid Kristen L · Intl Falls, MNBuilt 1956 · S/N 32477N6580EReady Aim Flyer LLC · New Castle, DEBuilt 1959 · S/N 56080N6580FLawson Jeremiah · Lunenburg, VTBuilt 1966 · S/N 15063180N6580GMonskey David Paul · Minnetonka, MNBuilt 1970 · S/N 15072080N6580TOlson Kenneth L · Raymond, WABuilt 1960 · S/N 17980N65813Northwest Wings LLC · Hillsboro, ORBuilt 1983 · S/N 17275896N65815Montgomery David A · Mancelona, MIS/N 17275897N6581GCox Martin S · Greenwood, INBuilt 1970 · S/N 15072081
Back to AD 79-10-14 R1