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.

N5075BParker Josh T · Fort Worth, TXBuilt 1955 · S/N D-4372N5075YAlkota Of Kansas LLC · Wichita, KSBuilt 2001 · S/N EA-675N5076CPrecision Design Inc · Weatherford, OKS/N D-2338N5076TDriffill Leroy R · Antonito, COS/N MA-324N5077CStack And Associates LLC · Coral Springs, FLS/N D-2380N5077TBerg Sanford B · Lakeville, MNBuilt 1968 · S/N MA-325N5078EBemidji Aviation Services Inc · Bemidji, MNBuilt 1963 · S/N LF-76N5078GFresh Air Aviation Inc · Charlevoix, MIBuilt 1960 · S/N LF-8N5078NBemidji Aviation Services Inc · Bemidji, MNS/N LF-16N5078UBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-32N5079COwens Robert B · Bryan, TXBuilt 1950 · S/N D-2341N5079EBemidji Aviation Services Inc · Bemidji, MNS/N LF-52N507TFairchild Property Management LLC · Monterey, CABuilt 1968 · S/N TC-1111N507TTCampo Feliz Aircraft Services LLC · Miami Lakes, FLS/N P-558N5080BQualitair LLC Trustee · MichelstadtBuilt 1955 · S/N D-4374N5080GQuinlan John H DBA · Claxton, GABuilt 1962 · S/N LF-35N5080HBemidji Aviation Services Inc · Bemidji, MNBuilt 1961 · S/N LF-27N5080LBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-59N5080RRodriguez Roberto F · Tampa, FLBuilt 2001 · S/N E-3386N5081BFisher Bruce C · Shoreline, WABuilt 1955 · S/N D-4364N5081CWagner Dixie Lee · Roswell, NMBuilt 1950 · S/N D-2343N5081EGolden Alan · Wilmette, ILBuilt 2001 · S/N E-3401N5082CJohnson Gregory J · Port Orange, FLBuilt 1950 · S/N D-2344N5083TClaar Brian · Spring, TXBuilt 1982 · S/N EA-287N5084CStalnecker William H · Lebanon, PABuilt 1950 · S/N D-2346N5084MFabrizio Timothy · Oswego, ILBuilt 1978 · S/N MC-571N5088TCox Stephen T · Fairborn, OHBuilt 1968 · S/N MB-343N508DFStephens James Anthony · Baton Rouge, LABuilt 1990 · S/N E2541N508MARms Beach Sierra LLC · Brownsville, TXBuilt 1975 · S/N MC-318N5090BHighland Investments LLC · Wilmington, DES/N D-4384N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34N5090TWoodcox Edmund A · West Monroe, NYBuilt 1968 · S/N MB-346N5091BDale Richard C · La Vernia, TXS/N D-4381N5092MZavalney Steven Michael · Canyon, TXBuilt 1978 · S/N MB-891N5092NMill-Run LLC · Lewes, DES/N D-9893N5092TZigo Daniel N · Madill, OKBuilt 1968 · S/N MB-347N5093BFe2 LLC · Washington, LABuilt 1955 · S/N D-4390N5093TTaylor Allen S · Oak Harbor, WABuilt 1968 · S/N MB-378N5094TKrass Roman · West Hills, CAS/N M-1137N5095BMoore Darrell R · Lake Stevens, WABuilt 1955 · S/N D-4393N5095TColter Duane E · Plainfield, INBuilt 1968 · S/N M-1138N5096BCooke Riley O · Bridger, MTBuilt 1955 · S/N D-4402N5097BJ P Sanders · Knoxville, TNBuilt 1955 · S/N D-4395N5099MBufo David · Los Osos, CABuilt 1978 · S/N M-2028N509JMRegistered aircraftBuilt 1980 · S/N D10352N50AKalabus Edward A Jr · Dallas, TXBuilt 1939 · S/N 271N50BDGoodrich Gilbert Joseph · Katy, TXS/N D-8175N50DMMiller Cory L · Winnsboro, TXBuilt 1960 · S/N TD-332N50GDTranguch John M · Beaver Meadows, PABuilt 1966 · S/N MA-128N50HGBethune David Scott · Stockton, CABuilt 1979 · S/N TJ-217
Back to AD 99-05-13 R1 WD