OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N3263LSale Reported · Arcata, CASale reportedBuilt 1967 · S/N 17256163N3263SBynum Albert L · Gadsden, ALBuilt 1964 · S/N 18255763N3264JB&K Used Auto & Equipment Llp · Fountain Run, KYBuilt 1966 · S/N 15065964N3264TVan Iderstyne Richard D · Jekyll Island, GABuilt 1967 · S/N 17700564N3265AMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9878N3265DMiller Matthew S · Washougal, WABuilt 1955 · S/N 32063N3265ETa Brand LLC · Middletown, DEBuilt 1978 · S/N 17271483N3265JFord-Umfuhrer Austin Donavan · Carrollton, GAS/N 15065965N3265SZehntner David R · Labelle, FLBuilt 1964 · S/N 18255765N3265UPreissler Daniel E · Giltner, NEBuilt 1963 · S/N 18254665N3266EN3266e LLC · Homestead, FLBuilt 1978 · S/N 17271484N3266LWolverine LLC · Roanoke, VABuilt 1967 · S/N 17256166N3266UVingers Michael T · Dellwood, MNBuilt 1963 · S/N 18254666N3267DDavidson Danny F · Anchorage, AKBuilt 1955 · S/N 32065N3267LBetter Fly Inc · Litchfield, ILS/N 17256167N3268JMiller Robert F · Locust Grove, GAS/N 15065968N3268KRegistered aircraftBuilt 1968 · S/N 17700519N3268SSquier Mark R · Lake Dallas, TXBuilt 1964 · S/N 18255768N3268TKawsara Sabah M · Fort Worth, TXBuilt 1967 · S/N 17700568N3268USchafer Gerhard Walter · Fairbanks, AKS/N 20956N326CFWestbank Fishing LLC · Kiln, MSBuilt 2001 · S/N 18281045N326EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13515N326LPVista Aviation Inc · Pacoima, CAFirst renewal noticeBuilt 2003 · S/N 172S9326N326MCJ&D Petroleum · Tallahassee, FLS/N 18281326N326MEAiry LLC · Seattle, WABuilt 2000 · S/N 172S8573N326PSPsl Surveys · Greenville, DEBuilt 2012 · S/N 18282344N3270DMcbride Robert W Jr · Cedar Park, TXBuilt 1955 · S/N 32068N3270UScott Brian W · Sagle, IDBuilt 1963 · S/N 18254670N3271AJohnson Jackson B · Wasilla, AKBuilt 1953 · S/N 25915N3271LHenson Raul Andre · Fox Island, WABuilt 1967 · S/N 17256171N3271UDallas Avionics Inc · Dallas, TXBuilt 1963 · S/N 18254671N3271YWoodbury Ivan D · Bowling Green, OHBuilt 1962 · S/N 18254271N3272TSonoras John G Jr · Newport, MIBuilt 1967 · S/N 17700572N3272YOlsen Chris M · Othello, WAS/N 18254272N3273DMonitor Ventures Group LLC · Anaheim, CABuilt 1973 · S/N 33701491N3273EAnderson Thomas J · Big Bear City, CABuilt 1978 · S/N 17271486N3273MLindeen Michael · Anchorage, AKBuilt 1967 · S/N 185-1210N3273SHepfer John E DBA · Midland, TXBuilt 1964 · S/N 18255773N3273TSommers Bradley D · Robinson, KSBuilt 1967 · S/N 17700573N3274DMcroberts David M · Washoe, NVBuilt 1955 · S/N 32072N3274EBitzer John · Cologne, MNBuilt 1978 · S/N 17271487N3274JOgrady John Thomas · West Chicago, ILBuilt 1966 · S/N 15065974N3274LHk Ventures LLC · Paynesville, MNS/N 17256174N3274TRinkle Michael G · Sussex, NJBuilt 1967 · S/N 17700574N3275DCrystoff James J · Kodiak, AKBuilt 1955 · S/N 32073N3275LMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 17256175N3276DFarkas Jonathan · Mukwonago, WIBuilt 1955 · S/N 32074N3276SLewinsky Marlon · Carrollton, TXBuilt 1964 · S/N 18255776N3276UNk Innovations LLC · Spokane, WABuilt 1963 · S/N 18254676N3277ALandry Anthony H · Port Orchard, WABuilt 1953 · S/N 25921
Back to AD 79-10-14 R1