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.

N376STymczyszyn William R · Torrance, CABuilt 1960 · S/N TD-378N3770QTaylor Zachary S · Shawnee, OKBuilt 1967 · S/N D-8403N3770ZScorpion Aviation LLC · Houston, TXS/N M-1118N3772QBoav8r LLC · Marana, AZBuilt 1967 · S/N D-8405N3775BMummy Mountain Med LLC · Paradise Valley, AZBuilt 1955 · S/N CH-187N3777JBeltz Richard D · Lehighton, PABuilt 1949 · S/N D-1908N3777SStuart Guy · Owosso, MIBuilt 2000 · S/N E-3351N377DShawn Wyatt Enterprises Inc · Huntsville, TXBuilt 1983 · S/N E-2087N377FCFlight Club LLC · Middle River, MDS/N WA238N377GGemini Southern LLC · Orlando, FLBuilt 1969 · S/N TC-1276N377KCEagle Flying Club LLC · Enid, OKBuilt 1977 · S/N E-1032N377RFGlobal Flight Support And Sales Inc · Tampa, FLBuilt 1987 · S/N CJ179N377TMuffler Ronald J Trustee · Salt Lake City, UTS/N E3416N377WBradley Aviation LLC · Whiteland, INS/N TE-683N3781QWelch Michael R · Roanoke, TXBuilt 1967 · S/N D-8417N3784BOgorek Peter J · Milwaukee, WIBuilt 1955 · S/N CH-200N3785QGo Fly Missoula LLC · Missoula, MTBuilt 1967 · S/N D-8413N3787DGlittenberg Bryson S · Rowlett, TXBuilt 1954 · S/N D-3787N3788QSale Reported · Oklahoma City, OKSale reported, canceledBuilt 1967 · S/N D-8410N3789GMentor 89g LLC · Kalispell, MTS/N G-737N3789QHercules Jesse T · Memphis, TNS/N D8412N378BJenkins Kenneth S · Milton Freewater, ORS/N D-5156N378GPE Graham Investments LLC · Sanford, FLBuilt 1975 · S/N CE-602N378JRay Preston C · Chula Vista, CABuilt 1967 · S/N D-8421N378TCampisi James R · Senoia, GABuilt 1963 · S/N D-7149N378YMeng Steven Jones · Garden Grove, CAS/N D-2680N3792GNogle Charles H · Champaign, ILS/N G-770N3793QMartin Tully T · Idalou, TXBuilt 1967 · S/N D-8418N3795BCanyon Aero LLC · Fresno, CABuilt 1955 · S/N CH-302N3795QGreen Aviation Inc · Manchester, MEBuilt 1967 · S/N TE-328N3797QKolb Norman R · Tijeras, NMBuilt 1967 · S/N D-8415N3798QMartin-Fosters Fuel Service Inc · Seminole, OKBuilt 1967 · S/N D-8416N37997Flying Brick LLC · Monroe, NCBuilt 1980 · S/N WA-190N3799GRounds Chris · Waller, TXS/N G-709N3799MWaldron Ronald · Strongsville, OHBuilt 1980 · S/N E-1774N3799QDtb Aviation Inc · Los Gatos, CABuilt 1967 · S/N D-8433N379JRDanny Skaggs Co Inc · San Antonio, TXBuilt 1984 · S/N TJ-447N379LV379lv LLC · Broomfield, COBuilt 1982 · S/N TJ423N379TCherney Cody L · Belleville, KSS/N D-7220N37BRC&D Pharmaceuticals Berry Inc · Berry, ALBuilt 1981 · S/N E-1860N37BSMatthew Davis · Asheville, NCBuilt 1974 · S/N E-548N37CHDehaan Aviation LLC · Bethel, AKBuilt 1979 · S/N E-1460N37DBCentral Virginia Aviation Inc · Petersburg, VABuilt 1974 · S/N P-309N37KBMccraw Michael · Myakka City, FLBuilt 1966 · S/N D-8046N37MCTvb Aviation LLC · Mcallen, TXBuilt 1988 · S/N CE-1258N37MKSkyhoundmedia Inc · Royal Oak, MIBuilt 1970 · S/N D-9168N37PAThree Rivers Aero LLC · Three Rivers, MIS/N TC-1267N37RAGustafson John A Trustee · Boulder City, NVBuilt 2001 · S/N E-3422N37RCCorrao Robert F Jr · Scottsdale, AZBuilt 1995 · S/N E-2986N37WBSterling Aviation Services Inc · Wilmington, NCBuilt 1955 · S/N CH-161
Back to AD 99-05-13 R1 WD