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.

N734UEJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1977 · S/N 17269118N734UFAlen Sergio Raul · Davie, FLFirst renewal noticeS/N 17269119N734UHSzymanski Collin A · Anchorage, AKS/N 17269121N734UL734ul LLC · Blaine, MNBuilt 1977 · S/N 17269124N734UMSweet Sunshine Produce Co LLC · Ocala, FLBuilt 1977 · S/N 17269125N734UPLee Randall Ross · Houston, TXS/N 17269127N734UQFuture Technologies Inc · Colonia, NJBuilt 1977 · S/N 17269128N734URKastle Todd Trustee · Gilroy, CAS/N 17269129N734USLowery Dwight W · Clayton, NCBuilt 1977 · S/N 17269130N734UTBlue Sky Aviation LLC · Menominee, MIBuilt 1977 · S/N 17269131N734UUPenn Aero LLC · Lewisburg, PABuilt 1977 · S/N 17269132N734UVCavu Flying Club · Wauwatosa, WIBuilt 1977 · S/N 17269133N734UWFisher Stephen C Trustee · Lamar, ARS/N 17269134N734UXJantz Carl R · Columbia, MOBuilt 1977 · S/N 17269135N734UYAg & Csv Inc · Pine Bush, NYBuilt 1977 · S/N 17269136N734UZDream Unthreatened LLC · San Luis Obispo, CABuilt 1977 · S/N 17269137N734VCNashville Skyscrapers LLC · Old Hickory, TNBuilt 1977 · S/N 17269140N734VEFlyby Aviation LLC · Logan, UTBuilt 1977 · S/N 17269142N734VNKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1977 · S/N 17269150N734VPBooth Danielle M · Somis, CABuilt 1977 · S/N 17269151N734VQJprg Aviation Inc · Orlando, FLBuilt 1977 · S/N 17269152N734VTDestination Aviation LLC · Destin, FLBuilt 1977 · S/N 17269155N734VVSummit Flight Services LLC · Paden, OKBuilt 1977 · S/N 17269157N734VXRed Door Aviation LLC · Dover, DEBuilt 1977 · S/N 17269159N734VZTri Air Inc · Aulander, NCBuilt 1977 · S/N 17269161N734WBWedoaero LLC · Vale, NCS/N 17269163N734WEMattie Joseph G · Ester, AKBuilt 1979 · S/N U20604883N734WFLewis Patrick K · El Dorado, ARS/N 17269167N734WKWagner James M · Hockessin, DEBuilt 1977 · S/N 17269171N734WLFlight Answers LLC · Miami Lakes, FLS/N 17269172N734WNBoerne Flight Options LLC · Boerne, TXBuilt 1977 · S/N 17269174N734WPLaps LLC · Elkhorn, WIBuilt 1977 · S/N 17269175N734WRSealy Michael Robert · Summerville, SCBuilt 1977 · S/N 17269177N734WSWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269178N734WXRegistration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1979 · S/N U20604886N734WZTingman Christopher · Seattle, WABuilt 1977 · S/N 17269185N734XCCurrier William R · Ormond Beach, FLBuilt 1977 · S/N 17269188N734XDByrne David · Three Rivers, MIBuilt 1977 · S/N 17269189N734XHFlyright Aviation Inc · North Las Vegas, NVS/N 17269193N734XKEllig Todd L · Horace, NDBuilt 1977 · S/N 17269195N734XLWalsh Patrick Sean · Osterville, MABuilt 1977 · S/N 17269196N734XMTri Star Cac LLC · Plano, TXBuilt 1977 · S/N 17269197N734XPDutcher John A · Cedar Falls, IAS/N 17269199N734XQSumter County Sheriffs Office · Sumter, SCBuilt 1977 · S/N 17269200N734XRWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269201N734XSCrabtree Clifford I · Ukiah, CABuilt 1977 · S/N 17269202N734XTFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N 17269203N734XXHuerta Holdings Inc · Santa Ana, CABuilt 1977 · S/N 17269207N734XYBend Aircraft Mechanics LLC · Bend, ORBuilt 1977 · S/N 17269208N734YALuxair LLC · College Station, TXBuilt 1977 · S/N 17269210
Back to AD 79-10-14 R1