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.

N621AKelsey John · Casa Grande, AZBuilt 1980 · S/N 21064069N621APEast Moriches Aerial Ads Ltd · Ridge, NYBuilt 1971 · S/N 15073078N621BKMy170b LLC · Everett, WAS/N 20819N621CLN621cl LLC · Overland Park, KSBuilt 1999 · S/N 18280618N621DCResource Extension LLC · Jupiter, FLBuilt 1980 · S/N 172RG0756N621GTFox Edward Philip Jr · New Market, ALS/N M337-0292N621MAAnderson Keith R · Norwood, MABuilt 1964 · S/N 15060905N621MRElliott Michael R · Friendswood, TXBuilt 1972 · S/N 15073969N621PMAtp Aircraft 1 LLC · Wilmington, DEBuilt 2012 · S/N 172S11177N621PWSkyten Flying Club Inc · Orefield, PABuilt 1976 · S/N 17702461N621SJAirmax Internet LLC · Troutman, NCBuilt 1979 · S/N 18267372N621TCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2000 · S/N 172S8506N621WHerzog Daniel L · Clinton, MIS/N 17248576N62209Christiansen Aviation LLC · Wilmington, DES/N 17275229N6220EStoudt Kristen D · Derby, KSBuilt 1958 · S/N 46320N6220FHeberle David B · Castroville, TXBuilt 1965 · S/N 337-0220N6220GDuncan Paul J · Bartlett, TNBuilt 1970 · S/N 15071720N6220KKasden Louis Jr · San Diego, CABuilt 1975 · S/N 15077595N6220NSchmidt Paul D · Derby, KSBuilt 1980 · S/N 18267803N6220TStorey Erik A · Fillmore, CABuilt 1964 · S/N 15060920N62217Wieken Peter J · Mount Joy, PABuilt 1968 · S/N R1720085N62218Above The Clouds Aviation LLC · Middletown, DEBuilt 1981 · S/N 17275230N6221AFlight Level Avionics & Maintenance Services LLC · Milton, FLBuilt 1956 · S/N 33021N6221EAllgeier David G Jr · Taylorsville, KYBuilt 1958 · S/N 46321N6221KWilson Steven J · Elkton, KYS/N 15077596N6222AAir Charter · Ottawa, ILBuilt 1956 · S/N 33022N6222EAlexander Tom · Alamogordo, NMBuilt 1959 · S/N 46322N6222FPhotos Unlimited · Rancho Cordova, CABuilt 1975 · S/N 18264128N6222GCosgrove Coleman · Juneau, AKBuilt 1970 · S/N 15071722N6222RBarge And Associates Inc · Houston, TXBuilt 1965 · S/N 15061522N6223BSpirek Aaron M · Henderson, NVBuilt 1978 · S/N 21062712N6223GGulasy Teresa L · Tulsa, OKBuilt 1970 · S/N 15071723N6223RBroadwell Eric · Woodstock, GABuilt 1965 · S/N 15061523N6223SKlingele Beth A · Wapato, WABuilt 1967 · S/N 15067023N6223VAxis Aviation LLC · Bloomingdale, GABuilt 1980 · S/N 172RG0593N62244Christiansen Aviation LLC · Wilmington, DES/N 17275234N62245Gabrieles Wings LLC · Oldwick, NJBuilt 2008 · S/N 172S10694N6224AAviation Of North Florida LLC · Jacksonville, FLS/N 33024N6224FMerrill James · Bigfork, MTBuilt 1975 · S/N 18264130N6225AMilpower Inc · Nampa, IDBuilt 1956 · S/N 33025N6225QElkinton Dusty Lee · Moundville, MOBuilt 1955 · S/N 31957N6225RHartman Michael F · Montclair, CABuilt 1979 · S/N 172RG0122N6225TMohnacky Robert A · Roscoe, ILBuilt 1964 · S/N 15060925N6226Lewis Jay C · Spanaway, WABuilt 1967 · S/N R172-0227N62266Skylens LLC · Hammond, LAS/N 17275239N6226ADaggett Aviation Inc · Daggett, CABuilt 1956 · S/N 33026N6226FLone Creek Ranch LLC · Williston, NDBuilt 1975 · S/N 18264131N6226KBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 1975 · S/N 15077599N6226RHamman Baron L · Dallas, TXS/N 15061526N6227AAllur Air LLC · Minnetrista, MNBuilt 1956 · S/N 33027
Back to AD 79-10-14 R1