OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N342BFritz John R · Chester, MTBuilt 1957 · S/N D-4927N342DBBeitler William · Washington, PABuilt 1999 · S/N G107N342SHorn Travis L · Clarksville, ARBuilt 1969 · S/N E-189N342UWelch Robert T · Alamogordo, NMBuilt 1971 · S/N D-9251N3430BChen Adeline B · West Lafayette, INBuilt 1953 · S/N D-3668N3435BHadley Paul T · Yelm, WABuilt 1953 · S/N D-3673N3436ARegistered aircraftBuilt 1970 · S/N TE-795N3436BRome Timothy · Garden City, KSBuilt 1953 · S/N D-3674N3439BSnyder Chris Allen · Benton, KSBuilt 1953 · S/N D-3677N343ABPonderosa 343 LLC · Richmond, VABuilt 2000 · S/N E-3343N343DBBrown Patrick T Trustee · Osceola, WIBuilt 1957 · S/N BG-317N343RBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N TC-1553N343ZMBuzzard Aviation LLC · St Simons Island, GABuilt 1955 · S/N G-303N3443Registered aircraftBuilt 1978 · S/N CE-761N3443BSwift Air International Inc · San Pedro, CAS/N D-3681N3445BNordhagen Melvin L · Spokane, WABuilt 1953 · S/N D-3683N3447BMahoney Christopher P · Quakertown, PAS/N D-3685N344BCote Stephen P · Montgomery, TXS/N D-4953N344SGGoldman Glenn D · VaughanBuilt 1957 · S/N BG354N3450SBoyes Robert Louis · Benton City, MOBuilt 1969 · S/N TC-1264N34549Octans Aviation Co · Watertown, SDS/N TK-62N3456AEl Aviation LLC · Alpena, MIBuilt 1977 · S/N P-443N3456GLawson Michael · Athens, TNBuilt 1952 · S/N D-3195N345BCScalera Dominic P · West Boylston, MABuilt 1960 · S/N D-6567N345CBR&E Bv LLC · Jupiter, FLBuilt 1961 · S/N D-6714N345CFLowery Ron L · Batesville, ARS/N E-2532N345CGHargis James L · Tioga, TXBuilt 1984 · S/N TJ-468N345CRAlbion Aviation LLC · Florence, SCBuilt 1994 · S/N E-2873N345DWalker Benjamin Kelly · Myrtle Beach, SCBuilt 1988 · S/N E-2422N345JHHurst James H · Longview, TXBuilt 1980 · S/N CE910N345PMMay Benjamin V Jr · Charlottesville, VABuilt 1961 · S/N D-6635N345URegistered aircraftBuilt 1971 · S/N E-263N345WFMullens Gregory · Spencer, OKS/N M-1815N345ZMetz Howard L · Los Angeles, CABuilt 1961 · S/N D-6713N3461BAnderson Daniel · Venus, TXS/N D-3687N3462BConner W Larry · Los Lunas, NMBuilt 1953 · S/N D-3688N3463BBeveridge Brothers LLC · Columbia, TNBuilt 1953 · S/N D-3689N3464BKimball James W · Mount Dora, FLBuilt 1953 · S/N D-3690N3465BMaxwell Spencer C · Sterling, KSS/N D-3691N346BGWebstrong Aviation LLC · Conway, ARBuilt 1973 · S/N D9494N346CSBooth Kristen E · Columbia, SCBuilt 1963 · S/N M-295N346ENorth Coast Aeronautical LLC · Cleveland, OHBuilt 1984 · S/N EA-409N346S200 Knot LLC · Amarillo, TXBuilt 1969 · S/N D-9092N3472BGroszer Todd A · Saint Marys City, MDBuilt 1953 · S/N D-3698N3474BYoung Donald L · Anniston, ALBuilt 1954 · S/N D-3700N3476AIsaacs Eugene E · Key West, FLS/N CE-294N347MJam Zoom Yayos LLC · Manheim, PABuilt 1981 · S/N EA-253N347TMccartney Matthew T · Lake Tapps, WABuilt 1962 · S/N D-7058N3486BCal Aerofab Flight Academy Inc · Chino, CABuilt 1954 · S/N D-3708N348GErickson Clarence B · Shreveport, LAFirst renewal noticeBuilt 1956 · S/N D-4532
Back to AD 99-05-13 R1 WD