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.

N9188CVail Jeffrey J · Rexburg, IDS/N 31287N9188GAircraft Management Services Inc · Milton, FLBuilt 1979 · S/N 17273625N9188KGallion David B · Michigan City, INBuilt 1968 · S/N 18259164N9188MSturgis Jason A DBA · Talkeetna, AKBuilt 1970 · S/N U20601588N9189AHoulton Timbre Ross · Fairbanks, AKBuilt 1949 · S/N 18950N9189BSale Reported · Litchfield, MNSale reportedBuilt 1958 · S/N 36789N9189CJastram Benjamin C · Lafayette, LABuilt 1954 · S/N 31288N9189HPendergrass Aviation Inc · Demopolis, ALBuilt 1975 · S/N 17266002N9189MFinnegan Patrick T · West Lafayette, INS/N 18264733N918CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8338N918CTBlinn Gilbert Trustee · Eastsound, WABuilt 1968 · S/N 18259387N918FAWestways Aviation LLC · El Cajon, CABuilt 1981 · S/N 17274981N918MYFlying Pigs LLC · Tulsa, OKBuilt 2005 · S/N 18281512N918PMMathews Roy · Bay Shore, NYBuilt 1980 · S/N 172RG0602N918TPAzure Quest LLC · Cleveland, TNBuilt 2007 · S/N 18281904N918VAVolatus Aerospace US Corp · Syracuse, NYS/N 17274912N918VPVanderpool Robert W · Red Devil, AKS/N 17266379N918VTChannel Islands Aviation Inc · Camarillo, CAS/N 17275241N918WMStone City Charters LLC · Anamosa, IABuilt 2008 · S/N 18282068N91900Lewis Jeery K · Cocolalla, IDBuilt 1969 · S/N 18259942N91907Skierka Christopher · Browning, MTBuilt 1969 · S/N 18259947N9190CDickamore Chris E · Lewiston, IDBuilt 1962 · S/N 18051202N9190MBgm Aero Inc · North Zulch, TXBuilt 1976 · S/N 18264734N91912Champagne Estates Inc · Wilmington, DEBuilt 1969 · S/N 18259949N91916Hanson Larry G · Seattle, WABuilt 1969 · S/N 18259950N91917Fairchild Chad E · Logandale, NVBuilt 1969 · S/N 18259951N91919Anderson Aerial Spraying Service Inc · Canby, MNS/N 18802053TN9191ARupert Judson L · West Milton, PABuilt 1950 · S/N 19366N9191BE & D Aviation Sales LLC · Sainte Genevieve, MOBuilt 1958 · S/N 36791N9191CBash Dennis W Jr · Wasilla, AKBuilt 1954 · S/N 31290N9191GFischer Gary H · Savannah, GAS/N 18260731N9191UN9191u LLC · California, MDBuilt 1976 · S/N 15078142N91920Brodel Adam · Grass Valley, CABuilt 2007 · S/N 18281921N91925Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17261524N91926Pacific Flying Association LLC · Aurora, ORBuilt 1969 · S/N 18259955N91928Moseley Michael S · Chelsea, ALBuilt 1969 · S/N 18259957N9192CBellamy Mark A · Freeville, NYBuilt 1955 · S/N 31291N9192GWg Aero LLC · Shreveport, LABuilt 1971 · S/N 18260732N9192MHandelin Gary W · Carson City, NVBuilt 1970 · S/N U20601592N91934N91934 LLC · Evergreen, COBuilt 2012 · S/N 17281613N91936Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281614N91937Munsell Kenneth L · Stuart, FLBuilt 1969 · S/N 18259961N9193ASchlafmann Jay R · Mercer, NDBuilt 1949 · S/N 18954N9193BRegistration Pending · Garwood, TXRegistration pendingBuilt 1958 · S/N 36793N9193GMach One Velocity LLC · Macomb Twp, MIBuilt 1979 · S/N 17273626N9193HPrairie Flyers Flying Club · Eudora, KSBuilt 1975 · S/N 17266006N9193TRich Edward L · Liberty, UTBuilt 1960 · S/N 50693N9193UVan Buskirk Bill J · Wasilla, AKBuilt 1976 · S/N 15078144N91941West Debra C · Dillon, COBuilt 1969 · S/N 18259963N91942Marvelous Margies Flying Club LLC · Helper, UTS/N 18259964
Back to AD 79-10-14 R1