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.

N4236BFisher Timothy G · Goddard, KSBuilt 1955 · S/N D-4209N4236DMatthew S Mcgaugh · Denton, NCBuilt 1956 · S/N D-4448N4237BKruger Kurt D · Delano, CABuilt 1955 · S/N D-4210N423BWFehring William · Sunnyvale, CABuilt 2000 · S/N EA-658N423JKKraft John · Lake View, IABuilt 1982 · S/N E1951N423MDSublett Charles M · Tulsa, OKBuilt 1964 · S/N D-7454N423PPrestige Worldwyde! LLC · Concord Township, OHBuilt 2002 · S/N E 3439N423WTCoons John K · Winston Salem, NCBuilt 1964 · S/N D-7426N423YEconome James S · Danville, CABuilt 1961 · S/N D-6845N4240BKent Ronald M · Fallon, NVFirst renewal noticeBuilt 1955 · S/N D-4214N4240DSummit Coastal Pllc · Carrboro, NCBuilt 1956 · S/N D-4460N4241DHilton Allen J A Jr · Justin, TXBuilt 1956 · S/N D-4461N4242BKingsbury Raymond S · Farmington, MNBuilt 1955 · S/N D-4216N4242DNielson Erik J · Erie, COBuilt 1956 · S/N D-4462N4244BHft Enterprises LLC · Wilburton, OKBuilt 1955 · S/N D-4218N4244DWarner Michael · Lexington, KYBuilt 1956 · S/N D-4459N4245AMac Flight LLC · Conway, ARBuilt 1970 · S/N D-9126N4246DFinnelly Daniel T · Pasco, WABuilt 1956 · S/N D-4468N4247BHarris Dan C · Rockford, TNS/N D-4221N4247DFussell L J · Broxton, GABuilt 1956 · S/N D-4465N4248BFreeman Lyman M · Golden Hills, CABuilt 1955 · S/N D-4224N4248DDrangle Bruce · Gilman, WIBuilt 1956 · S/N D-4455N424BDenney Jody M · Mcminnville, TNS/N D-1598N424JBJsj Aircraft Holdings LLC · San Diego, CAS/N CE-1363N424NMSky West Aviation Inc Trustee · Albuquerque, NMS/N BG-59N424TCyphers Russell W · Phoenix, AZS/N D-6806N4250B623gj LLC · Aitkin, MNBuilt 1955 · S/N D-4226N4251BOliver Rodney W · Houston, AKBuilt 1955 · S/N D-4227N4252BSexton Kenneth Wade · Baker, FLBuilt 1955 · S/N D-4228N4252DTravis Tom · Dallas, TXBuilt 1956 · S/N D-4469N4253DCustis James G · Denver, COS/N D-4470N4254BOsgood Nathan · Toa Baja, PRBuilt 1955 · S/N D-4231N4254DKlna Bonanza LLC · Lake Worth, FLBuilt 1956 · S/N D-4471N4255DSprague Dale M · Mcpherson, KSBuilt 1956 · S/N D-4478N4255STeton River Flying Service Inc · Rexburg, IDBuilt 1976 · S/N TK-35N4256DBishop Herbert O Trustee · Reno, NVBuilt 1956 · S/N D-4482N4257BLindell Michael V · Aledo, ILBuilt 1955 · S/N D-4234N4257DPeterson Duane T · Milwaukee, WIS/N D-4485N4257ST&S Proch Investments LLC · Harrisonville, MOBuilt 1976 · S/N E-939N4258DRexrode Rocky · Frankston, TXBuilt 1956 · S/N D-4473N4259BRucker Paul D · Roanoke, VABuilt 1955 · S/N D-4236N425MGGrinnan Michael · Stafford, VAS/N D-7813N425PQuimus Aviation LLC · Townsend, WIBuilt 1998 · S/N E-3175N4260BWall Robert J Jr · Clanton, ALS/N D-4237N4260DBrownlee Craig · Knoxville, TNBuilt 1956 · S/N D-4474N4260SMueller Phillip Robert · Newbury Park, CABuilt 1977 · S/N E-959N4262SPeck Crosby S · Meredith, NHS/N E-942N4263DMartin Scott A · Lizton, INBuilt 1956 · S/N D-4477N4265BSmith Steven C · Orting, WABuilt 1955 · S/N D-4242N4266DCureton Tony G · Port Huron, MIBuilt 1956 · S/N D-4486
Back to AD 99-05-13 R1 WD