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.

N3382YJenkinson John III · Lakin, KSBuilt 1962 · S/N 18254382N3383DStyer Michael J · Amarillo, TXBuilt 1955 · S/N 32181N3383RDeatley Derek · Mohave Valley, AZBuilt 1967 · S/N 18258683N3383SStewart Bryan · Carson City, NVBuilt 1969 · S/N 21059183N3383TBerkstresser John A · Ellijay, GABuilt 1967 · S/N 17700683N3383YJohnson Brian B · Monroe, LABuilt 1962 · S/N 18254383N3384R3384 Romeo LLC · Jackson, MOBuilt 1967 · S/N 18258684N3384VNewby Aviation LLC · Pingree Grove, ILS/N 15076484N3384YOliveira John S · Plant City, FLBuilt 1962 · S/N 18254384N3385JGonzales Mark S · Dothan, ALS/N 15066085N3385LTonka Seaplanes LLC · Minnetonka, MNS/N 185-1337N3385RHill David A Jr · Needham, MABuilt 1967 · S/N 18258685N3385YNoah Aviation LLC · Ellabelle, GABuilt 1962 · S/N 18254385N3386ED Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 17271526N3386FN3386f Flying Club Inc · Pickerington, OHBuilt 1966 · S/N 18257386N3386VFrg III Inc DBA · Lincoln Park, NJBuilt 1974 · S/N 15076486N3387FChristensen Robert F · Gillette, WYBuilt 1966 · S/N 18257387N3387JMy Piper Pacer LLC · Everett, WAS/N 15066087N3387RSkypartners LLC · Buhler, KSBuilt 1967 · S/N 18258687N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687N3387USkynick Enterprises Inc · Tarzana, CAS/N 18254787N3387YBhogal Balvinder S · Biloxi, MSBuilt 1962 · S/N 18254387N3388RFamily Air Fares LLC · Wilmington, DEBuilt 1967 · S/N 18258688N3388SShaffer Barbara J · Franklin, KYBuilt 1969 · S/N 21059188N3388TKing Eric J · Zillah, WABuilt 1967 · S/N 17700688N3388UMenard Charles H · Grand Blanc, MIBuilt 1963 · S/N 18254788N3388YMeeks Peris M · Gardena, CAS/N 18254388N3389DRegistered aircraftBuilt 1955 · S/N 32187N3389EBarnfather James D · Sequim, WABuilt 1978 · S/N 17271528N3389UThompson Anthony D Trustee · Rockwall, TXS/N 18254789N338BMMorton William · Darby, MTBuilt 1979 · S/N 18267111N338CALincoln Skyways Inc · Lincoln, CABuilt 1978 · S/N 17269465N338GSSanders Flight Training Center Inc · Jasper, ALBuilt 2025 · S/N 172S13326N338HCapital Holdings Fund IV LLC · Boca Raton, FLBuilt 1982 · S/N 18504343N338LMSisk Stephen A · Greenville, ILBuilt 1968 · S/N 18259244N338MEBoulant Michael Lee Charles · Las Vegas, NVBuilt 2000 · S/N 18280730N338TLMargolis Michael · Ruskin, FLBuilt 1973 · S/N 33701563N3390FRodgers Christian Joseph · Ormond Beach, FLS/N 18257390N3390JVandyke Dennis C · Rose Hill, VABuilt 1967 · S/N 15066090N3390TTucker Lon R · East Peoria, ILBuilt 1967 · S/N 17700690N3390YHead John T Jr · Port St Joe, FLS/N 18254390N3391EOcala Aviation Services Inc · Ocala, FLBuilt 1978 · S/N 17271529N3391FKingston Terry D · Irving, TXBuilt 1966 · S/N 18257391N3391TCardinal Wings LLC · Middletown, DEBuilt 1968 · S/N 17700691N3392DHaszard John R · Ophelia, VABuilt 1955 · S/N 32190N3393TWilcox Russell J · Salinas, CABuilt 1967 · S/N 17700693N3394DCartledge Charles J · Orrville, OHBuilt 1955 · S/N 32192N3394RCurren Patrick V · Green Bay, WIBuilt 1967 · S/N 18258694N3394TPekrul Eric C · Frankfort, MIBuilt 1968 · S/N 17700694N3394YNolt Ivan M · Mount Solon, VABuilt 1962 · S/N 18254394
Back to AD 79-10-14 R1