OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N2221YThomas Raymond N · Springfield, SDBuilt 1967 · S/N 17700021N2221ZFielding David J · Scarborough, MEBuilt 1962 · S/N 1850319N2222DAsbury Charles E · Valley Center, KSBuilt 1952 · S/N 20374N2222GCaswell Matthew N · Lubbock, TXBuilt 1958 · S/N 51522N2222WJohnson Linzy A · Lake Stevens, WABuilt 1951 · S/N 19960N2222XOrtiz Stewart Flynn · San Diego, CAS/N 337-0122N22230Paulsen Bryant A · Lynden, WABuilt 1974 · S/N 17264059N22232Engeseth James Jr · Parker, COBuilt 1972 · S/N 21059730N22237Aviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S10025N2223CElston Josh A · Sterling, AKBuilt 1953 · S/N 30523N2223GS & M Partnership · Jasper, TXBuilt 1958 · S/N 51523N2223SDavis Aaron B · Lascassas, TNBuilt 1976 · S/N 21061168N2223TC & R Leasing LLC · Fairbanks, AKBuilt 1968 · S/N 185-1375N2223UDylans Rv Center LLC · Waterford, NJBuilt 2005 · S/N 18281677N2223YReynolds David Keith · Bastrop, LABuilt 1967 · S/N 17700023N22243Crawford Stephen E · Corinth, TXS/N 15068162N22245Vanderploeg Connie · Edmond, OKBuilt 1967 · S/N 15068164N2224EReiss Dennis · Wilcox, NEBuilt 1952 · S/N 20354N2224J24j LLC · Driggs, IDBuilt 1966 · S/N 15065424N2224XRegistered aircraftBuilt 1965 · S/N 337-0124N22250Rush Christopher C · Anchorage, AKBuilt 1967 · S/N 15068167N22251Barber Michael L · Igo, CABuilt 1967 · S/N 15068168N22252Heid Nathan E · Nevada, OHBuilt 1967 · S/N 15068169N22253Blue Sky Investments LLC · Fayetteville, NCBuilt 1967 · S/N 15068170N22255Rodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 15068172N2225AFreedom Aviation Inc · Lynchburg, VABuilt 2007 · S/N 172S10467N2225EQuad City Area Flying Eagles Inc · Milan, ILS/N 18260377N2225FTextron Aviation Inc · Wichita, KSBuilt 2007 · S/N 172S10468N22260Arnold James R · Latrobe, PABuilt 1967 · S/N 15068174N22265Edb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S10026N2226RChampion Crane Service Inc · Des Moines, IABuilt 1968 · S/N T210-0376N2226SE S P Aviation LLC · Wilmington, DEBuilt 1976 · S/N 21061171N2226YRamjattan Enarl A · Harahan, LABuilt 1967 · S/N 17700026N22271Ps N22271 LLC · Green Bay, WIBuilt 1974 · S/N 17264061N22276Ramsey Lenny J · Greeneville, TNBuilt 1968 · S/N 15068185N22277Gage Rodney L · Oak Grove, ARS/N 15068186N2227FBay Area Aviation LLC · Beach City, TXBuilt 2005 · S/N 18281681N2227YAdam Lewis W · Chiefland, FLBuilt 1967 · S/N 17700027N22284Fenton Ted P · Rushville, MOS/N 15068191N22285Barlow Richard B · Stockbridge, GABuilt 1968 · S/N 15068192N2228GHalo Halo LLC · Milwaukie, ORS/N 51528N2228SHannaford Edward M · Roseville, MIBuilt 1976 · S/N 21061173N22297Trissell Flying Service Inc. · Clarksville, TXBuilt 1968 · S/N 15068199N2229CYleski LLC · Bozeman, MTBuilt 1953 · S/N 30529N2229DN2229d LLC · Wilmington, OHBuilt 1952 · S/N 20381N2229ESix Pack Aviation LLC · Pocono Pines, PABuilt 1978 · S/N 17271193N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174N2229XByers Gary F · Wasilla, AKBuilt 1969 · S/N 185-1509N222AKChambers Samuel S · Salmon, IDBuilt 1953 · S/N 30097N222ATSierra 1 Tech Inc · Blue Jay, CABuilt 1968 · S/N 21059098
Back to AD 79-10-14 R1