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.

N5873R3 Points LLC · Comstock Park, MIBuilt 1965 · S/N 17253542N58742Vaughn Michael R · Summersville, MOBuilt 1973 · S/N 18262269N58747Martin Robert Daniel · Little Rock, ARBuilt 1973 · S/N 18262272N5874AShaha Zachary D · Menomonie, WIBuilt 1956 · S/N 28474N5874BTravis Clay · Hopkinsville, KYBuilt 1956 · S/N 33874N5874RHammel Tyler S · Dufur, ORBuilt 1965 · S/N 17253543N5875ARoberts Dallon W · Kamiah, IDS/N 28475N5875BFerguson Bruce W · Fort Peck, MTBuilt 1956 · S/N 33875N5875RHepburn Joseph C · Towanda, KSBuilt 1965 · S/N 17253544N58763Downwind LLC · Clancy, MTBuilt 1973 · S/N 18262280N58766Gonzalez Tomas · Windham, NHBuilt 1973 · S/N 18262282N5876AThomas Christopher D · Santa Monica, CABuilt 1956 · S/N 28476N5876EFoster Garry R · Advance, NCBuilt 1959 · S/N 17376N5876RJasmer Craig G · Puyallup, WABuilt 1965 · S/N 17253545N58771Casas-Dolz Raul · Dickinson, NDBuilt 1973 · S/N 18262284N58773Ranchers Skylane LLC · Newcastle, WYBuilt 1973 · S/N 18262286N58776Wild River Flying Club Inc · Saint Croix Falls, WIBuilt 1973 · S/N 18262288N58778Bell Bradley J · Searcy, ARBuilt 1973 · S/N 18262290N5877AMangham Aviation LLC · Mullin, TXBuilt 1956 · S/N 28477N5877GClegg Stephen A · Port Orange, FLBuilt 1969 · S/N 15071377N5877RRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1965 · S/N 17253546N5877TLeaders Kurt W · Clear Lake, MNS/N 185-0777N58780Sksp LLC · Brandon, FLBuilt 1973 · S/N 18262291N5878BRobel Timothy R · Yakima, WABuilt 1956 · S/N 33878N5878ESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 17271949N5878FVanreeth Philip J Jr · Woodstock, ILBuilt 1967 · S/N 21058878N58790Ego IV Aviation Consulting LLC · Goose Creek, SCBuilt 1973 · S/N 18262295N58793Summers Randall L · Weslaco, TXBuilt 1973 · S/N 18262298N58794Lagos Ricardo · Seattle, WABuilt 1973 · S/N 18262299N58798Tailwind Aviation Holdings LLC · Austin, TXS/N 18262303N5879EDrennan Monte Dean · Caddo, OKBuilt 1959 · S/N 17379N587BCBlacow Kenneth Michael · Key West, FLBuilt 1979 · S/N 18267419N587ERTextron Aviation Inc · Wichita, KSS/N 172S13614N587SPPinnacle Aviation Services Inc · Encinitas, CABuilt 2000 · S/N 172S8518N58800S&Hb Sky LLC · Heyburn, IDBuilt 1973 · S/N 18262304N5880ENashville Skyscrapers LLC · Old Hickory, TNBuilt 1978 · S/N 17271950N58812F And L Properties · Magnolia, ARBuilt 1973 · S/N 18262312N58818Jk Homes LLC · Idaho Falls, IDS/N 18262317N5881RRengel Ronald J · Mundelein, ILBuilt 1965 · S/N 17253550N58821Canipe Rachel B · Shelby, NCBuilt 1973 · S/N 18262319N58823Silverbullet LLC · San Francisco, CABuilt 1973 · S/N 18262321N5882BValley Air Inc · Natchitoches, LAFirst renewal noticeBuilt 1956 · S/N 33882N5882RGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17253551N58830Frisbee Ralph · Valley Park, MSBuilt 1973 · S/N 18262326N58832Wiley Eleven Eleven Ltd · Hayward, WIBuilt 1973 · S/N 18262328N5883EHowser Kevin E · Fort Ashby, WVBuilt 1959 · S/N 17383N5883GDerry Delmar D · New Market, IABuilt 1969 · S/N 15071383N58843Kcn Aero Club Inc · Overland Park, KSBuilt 1973 · S/N 18262335N5884ADe Witt Duane A · Colleyville, TXBuilt 1956 · S/N 28484N58851Crimm Sam II · Tullahoma, TNBuilt 1973 · S/N 18262342
Back to AD 79-10-14 R1