OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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-03-R2')
    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-03-R2')
  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.

N264JSAllen James M · Gilmanton, NHBuilt 1993 · S/N 21522N264LWilder Paul D · Chattanooga, TNBuilt 2003 · S/N 23323N264MAShaffer John C · Talkeetna, AKBuilt 2004 · S/N 482-2004N264NDPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 28-42069N264SASundance Airport LLC · Yukon, OKBuilt 1968 · S/N 28-25258N26507Musgrave John R · Morris, ILS/N 1958N2650PGodlewski John A · Ormond Beach, FLS/N 22-2988N2651WStolworthy Spencer D · Maple Valley, WABuilt 1966 · S/N 3307N2651ZHelburg Michael L · Libby, MTS/N 1004-77N2652THart William · West Plains, MOBuilt 1971 · S/N 28-7205063N2652WRegistered aircraftBuilt 1966 · S/N 3308N2653PKoerner Stephen F · Kankakee, ILBuilt 1955 · S/N 22-2993N2654PSamson Mason H · Rives Junction, MIBuilt 1955 · S/N 22-2994N2656TCardinal Point Aviation Services LLC · Homestead, FLBuilt 1971 · S/N 28-7225079N2657MCurtis Christopher J · Wasilla, AKBuilt 1946 · S/N 12-970N2657WRegistered aircraftBuilt 1966 · S/N 3310N2658TLoer Stanley W · Grants Pass, ORBuilt 1971 · S/N 28-7205067N265AAWhitten Chris K · Alton, MOBuilt 1958 · S/N TD-132N265ACMorgan Nigel · Asheville, NCBuilt 1998 · S/N 407-98N265ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496098N265BHillestad Darrell · Aberdeen, SDS/N 25N265BSGrant Charles K · Topton, NCS/N 454N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081N265NDAri Ben Aviator Inc · Fort Pierce, FLS/N 2842065N26602Eastern New Mexico University - Roswell · Roswell, NMBuilt 1988 · S/N 0858N2660AN62689 Inc · Texarkana, TXBuilt 1952 · S/N 18-2184N2660PAnderson William B · Rogers, ARBuilt 1955 · S/N 22-3000N2660QSummit Aviation LLC · Spokane, WABuilt 1977 · S/N 28-7790413N26619Sides Michael E · Bartley, NEBuilt 1988 · S/N 0876N2661TSix One Tango LLC · Pismo Beach, CABuilt 1971 · S/N 28-7205069N2662TPlane Aviation LLC · Camarillo, CABuilt 1971 · S/N 28-7205070N2662WEaton Mark E · Houston, TXBuilt 1966 · S/N 3312N2663JN2663j LLC · Rehoboth Beach, DEBuilt 1988 · S/N 0877N2663PHoffrage Michael B · Fresno, CAS/N 22-3003N2664AZmuda Bruce V · Eagle River, AKBuilt 1952 · S/N 18-2179N2664KPeters Jeremy D · Nampa, IDBuilt 1947 · S/N 5391N26655Weyhe Joan Monica · Medford, ORBuilt 1978 · S/N AA5A0623N2665ZRegistered aircraftBuilt 1978 · S/N 351-78N26661Barber William M · Alden, MIBuilt 1978 · S/N AA5A0547N26664Grumman N26664 LLC · Charlotte, NCBuilt 1977 · S/N AA5A-0518N2666PBerentson Bradley J · Westhope, NDBuilt 1955 · S/N 18-4390N26670Ward John L · Mexia, TXBuilt 1978 · S/N AA5A0628N26675Kilmurry Thomas · Charlotte, NCBuilt 1978 · S/N AA5A0639N26679Kennann Christopher D · Lubbock, TXS/N AA5A0641N2667ZHite Loren E · Fairbanks, AKBuilt 1978 · S/N 264-78N26684Stanard Paul J · Moreland Hills, OHBuilt 1978 · S/N AA5A0644N26685Le Pendu Claude E · Fruit Heights, UTBuilt 1978 · S/N AA5A0645N26688Kirker Edmund J · Omaha, NEBuilt 1978 · S/N AA5A0647N2668PRegistered aircraftBuilt 1955 · S/N 18-4392N2668TKing Thomas S · Boerne, TXBuilt 1971 · S/N 28-7205092
Back to AD 79-10-03 R2