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.

N759SLSirmon James A · Daphne, ALBuilt 1978 · S/N 18266222N759SPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N 18266225N759SRMazz Airplane 1 LLC · Elbert, COBuilt 1978 · S/N 18266227N759TAKay Betty T · Brigham City, UTBuilt 1978 · S/N 18266236N759TDHollingshead Michael · Murfreesboro, TNS/N 18266239N759TFGardner Robert · Bellevue, IDBuilt 1978 · S/N 18266241N759TGTwgr LLC · Amarillo, TXBuilt 1978 · S/N 18266242N759THJones Darrell · Columbia, MOS/N 18281219N759TJFlying Anchor Aviation LLC · Seattle, WABuilt 1978 · S/N 18266244N759TMCastro Joseph · Boston, MABuilt 1978 · S/N 18266247N759TNAir Charter Inc DBA · Culebra, PRBuilt 1978 · S/N 18266248N759TPItaliano William S Jr · West Boylston, MAS/N 18266249N759TRArnold Scott J · Xenia, OHBuilt 1978 · S/N 18266251N759TSWinter Kevin A · Ravensdale, WABuilt 1978 · S/N 18266252N759TTTrend Companies LLC · Phoenix, AZBuilt 1978 · S/N 18266334N759TURobeck Troy D · Okanogan, WABuilt 1978 · S/N 18266254N759TVJimmy Mac LLC · Sun Valley, IDBuilt 1978 · S/N 18266255N759TYKoopman Allen W · Lake Forest Park, WABuilt 1978 · S/N 18266257N759UCCozart Marlon R · Azle, TXBuilt 1978 · S/N 18266261N759UHAyerstech LLC · Chetek, WIBuilt 1978 · S/N 18266266N759UJKing Forest Ind Inc · Wentworth, NHBuilt 1978 · S/N 18266267N759ULJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266269N759UQPatrick William B · Newport News, VABuilt 1978 · S/N 18266273N759URStenzel Richard J · Imperial, PABuilt 1978 · S/N 18266274N759USFly Ab Inc · Fort Lauderdale, FLBuilt 1978 · S/N 18266275N759UUMeyerson Sanford · Smithville, TXBuilt 1978 · S/N 18266277N759UVChamberlain Noreen J · Douglas, WYBuilt 1978 · S/N 18266278N759UWKaufmann Michael A · Brownsburg, INBuilt 1978 · S/N 18266279N759VPacific Coast Aero LLC · Torrance, CAFirst renewal noticeBuilt 1978 · S/N 18266286N759VGDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 18266289N759VHSaguto Peter J · Ballwin, MOBuilt 1978 · S/N 18266290N759VJMoffitt John S · San Jose, CAFirst renewal noticeBuilt 1978 · S/N 18266291N759VMJuliet Mike Holdings LLC · Friendswood, TXBuilt 1978 · S/N 18266294N759VNHoney Cross Farms P/S · Lafayette, LABuilt 1978 · S/N 18266295N759VPLewis Elliott Mcmorran Vaden Ragsdale & Woodward · Little Rock, ARBuilt 1978 · S/N 18266296N759VVHumble John A · Liberal, KSBuilt 1978 · S/N 18266302N759VYAms Aviation LLC · South Bend, INBuilt 1978 · S/N 18266305N759WDTootle Equipment Co Inc · Reidsville, GABuilt 1978 · S/N 18266310N759WERegistration Pending · Cottonwood, AZRegistration pendingBuilt 1978 · S/N 18266311N759WGFtm Falcon LLC · Arnold, MDBuilt 1978 · S/N 18266313N759WKLee Kevin J · Dunn, NCBuilt 1978 · S/N 18266316N759WLStolyarov Yury M · Brookline, MABuilt 1978 · S/N 18266317N759WMJames Brent A · Royal, ARBuilt 1978 · S/N 18266318N759WNSmith Kristopher D · Wickenburg, AZBuilt 1978 · S/N 18266319N759WPSale Reported · Farmington, MOSale reported, pending cancellationBuilt 1978 · S/N 18266320N759WRAlmond Kevin L · Waxahachie, TXBuilt 1974 · S/N 18263231N759WSCottrell David J · Anchorage, AKBuilt 1978 · S/N 18266322N759WWLeading Edge Aviation Services Inc · Missoula, MTBuilt 1978 · S/N 18266326N759WZMario J Khoury · Pasadena, CABuilt 1978 · S/N 18266329N759XBjorlie Paul A · Pekin, NDBuilt 1977 · S/N 18266003
Back to AD 79-10-14 R1