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.

N7140QMagnuson Jessica M · Olathe, KSBuilt 1972 · S/N 17260440N7140SRegistration Pending · Bermuda Dunes, CARegistration pendingBuilt 1976 · S/N 18265069N7141AFarruggia John A · West Winfield, NYBuilt 1956 · S/N 29241N7141CLongview Iron LLC · Longview, TXBuilt 2015 · S/N 18282375N7141EBobek Janice C · Soldotna, AKBuilt 1959 · S/N 52141N7141GDyke Paul A · Hartford, SDBuilt 1969 · S/N 17258841N7141JHutt Aviation Inc · Minden, NVS/N 17273902N7141QFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260441N7141TRosser David S · Lynn, ALBuilt 1959 · S/N 46741N7141XWells Brent R · Atascadero, CABuilt 1961 · S/N 15059241N71420Yeti Aviations LLC · Madison, ALBuilt 1969 · S/N 18259616N7142EDuncan Wayne K Trustee · Athol, IDBuilt 1959 · S/N 52142N7142QObymachow Richard M · Killingworth, CTS/N 17260442N7142RWirick Neil · Cable, OHS/N 18282454N7142XTownsend Charles D · Portage, MIBuilt 1961 · S/N 15059242N71430Princeton Raptors Flying Club · Princeton, MNS/N 17263380N7143EPfisters Flying Wahine LLC · Waialua, HIBuilt 1959 · S/N 52143N7143GAllen Nathanael W · Bemidji, MNBuilt 1969 · S/N 17258843N7143MMiles Richard B · Lompoc, CABuilt 1958 · S/N 55443N7143QMcgraw Warren R · Pineville, WVBuilt 1973 · S/N 18262036N71444Rushville Flying Club Inc · Rushville, ILBuilt 1975 · S/N 172-65662N7144GJc Flight Inc · Wilmington, DEBuilt 1969 · S/N 17258844N7144MKeno Dale J · Worley, IDBuilt 1958 · S/N 55444N7144QJungle Breezes Youth Ministries · East Earl, PABuilt 1975 · S/N U20603075N7144SLet There Be Flight LLC · Portage, MIBuilt 1967 · S/N 15067844N71450Ejs Enterprises Inc · Three Forks, MTBuilt 1969 · S/N 18259627N71452Blay Jeffrey E · Oak Harbor, OHBuilt 1969 · S/N 18259629N7145EJones Robert · Anchorage, AKBuilt 1959 · S/N 52145N7145QEdling Tyrell R · The Dalles, ORBuilt 1973 · S/N 18262038N7145TZacharias Norman R · Hinckley, MNFirst renewal noticeBuilt 1959 · S/N 46745N7145XAthol Orange Aero Club Inc · Athol, MABuilt 1961 · S/N 15059245N71462Shaffer Jessie J · Peyton, COBuilt 1969 · S/N 18259632N71463Rodrigo Jodi L · Orland, CABuilt 1969 · S/N 18259633N7146FR And R Plane LLC · Lewiston, IDBuilt 1966 · S/N 15063746N7146GHalladay Roy · Erie, COBuilt 1969 · S/N 17258846N7146MWright Roy E · Tulelake, CABuilt 1958 · S/N 55446N7146QPressley Aviation LLC · New London, NCBuilt 1972 · S/N 17260446N7146YRoberts George M · Houston, TXBuilt 1966 · S/N 337-M0399N7147AAir Cover Academy LLC · Frankford, MOBuilt 1956 · S/N 29247N7147FHernandez Jorge L · Luthersville, GABuilt 1966 · S/N 15063747N7147GAffordable Flying LLC · Cedar Park, TXBuilt 1969 · S/N 17258847N7147TMoody George A II · Dyersburg, TNBuilt 1959 · S/N 46747N7147XBrooks Blaze W · Fairbanks, AKBuilt 1961 · S/N 15059247N71484Noss David L Jr · Hominy, OKBuilt 1969 · S/N 18259637N7148EBush Dale L · Medford, ORBuilt 1959 · S/N 52148N7148FHigh Flight Aviation Of Kentucky Inc · Lexington, KYFirst renewal noticeBuilt 1966 · S/N 15063748N7148QRosevelt Jane · Lake Oswego, ORBuilt 1999 · S/N 18280553N7148SJupiter Flight Service And Investing LLC · Lithonia, GAS/N 15067848N7148XLong Thomas S · Longview, TXBuilt 1961 · S/N 15059248N71491Kelley Philip W · Titus, ALBuilt 1969 · S/N 18259641
Back to AD 79-10-14 R1