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.

N606TWhitney Richard E Jr · Warrenton, VABuilt 1977 · S/N E-1155N6070EBas Part Sales LLC · Greeley, COBuilt 1959 · S/N D-6022N6070NKnott Donnie W · Milan, TNBuilt 1968 · S/N M-1164N6070SEdward C Kole · Lake Geneva, WIBuilt 1975 · S/N D-9822N6071EBoltz Leonard E · Pearson, WIBuilt 1959 · S/N D-6021N6072EKnott Thomas · Clinton, MOBuilt 1959 · S/N D-6027N6072NDilecce Joseph · Sarasota, FLBuilt 1969 · S/N M-1209N6072SMiller Walter Timothy · Henderson, NVBuilt 1975 · S/N D-9823N6073NRozinka Jay C · River Falls, WIBuilt 1968 · S/N M-1166N6073SLocke Mary · Sherman, TXBuilt 1975 · S/N E-776N6074NParlog Roy H · Irwin, PABuilt 1968 · S/N M-1167N6074SWatson Glenn M · Round Rock, TXBuilt 1975 · S/N E-778N6075SJohnson Jamie D · Leonard, TXBuilt 1975 · S/N E-780N6077NKrig Marie · Seattle, WABuilt 1969 · S/N M-1202N6077SMcdaniel Leigh W · Orland, CABuilt 1977 · S/N E-962N6079STelevision Technical Consultants Inc · South Bend, INBuilt 1975 · S/N TC-1877N607BKovas Dale K · New Carlisle, INBuilt 1948 · S/N D-1628N607GSGaines Robert G · Howell, MIBuilt 1982 · S/N TK-147N6080NHuberty Gregory N · Circle Pines, MNBuilt 1969 · S/N M-1204N6081NTamim Shekaib · Tracy, CABuilt 1968 · S/N M-1174N6081STearse David S · Swisher, IABuilt 1975 · S/N TE-1069N6082NNewberg G Edward · Haines City, FLBuilt 1969 · S/N M-1175N6082SWro LLC · Conway, ARS/N TC-1914N6083ESwisher Michael S · Yukon, OKBuilt 1959 · S/N D-6052N6084EMargart Geoffrey W · Mount Shasta, CABuilt 1959 · S/N D-6097N6084NHilpertshauser David J · Sheboygan, WIBuilt 1969 · S/N M-1184N6084SGraves Dorel Jr · Danville, INBuilt 1975 · S/N TC-1913N6085NShuffield Brian D · Oregon House, CAS/N M-1177N6087SVega Peter · Thrall, TXBuilt 1975 · S/N E-784N6089SVincent Shawn P · Hinsdale, ILFirst renewal noticeBuilt 1975 · S/N CE-617N608BMacario T Michael · Townsend, DEBuilt 1955 · S/N D-4279N608EBPinnacle Roof Solutions LLC · New Baden, ILBuilt 1979 · S/N E-1512N608QDoss Steven V · New Orleans, LABuilt 1959 · S/N D-5888N608RBKnudsen Russell G · East Troy, WIBuilt 1968 · S/N D-8818N6091SAir Transport Inc · Liberal, KSBuilt 1975 · S/N E-787N6092EHasan Reas · Raleigh, NCBuilt 1959 · S/N D-6069N6092SRobinson David John · Eads, TNBuilt 1975 · S/N D-9830N6093SFarmer Scott · Springtown, TXBuilt 1975 · S/N D-9826N6094NAmerican Aviator LLC · Arlington, TXBuilt 1968 · S/N MA-336N6094RBoston Executive Helicopters LLC · Norwood, MABuilt 1979 · S/N M-2209N6096EEuroaviation Inc Trustee · KematenS/N D-6036N6097ERay Michael S · Charlotte, NCBuilt 1959 · S/N D-6107N6097SDonbee Farms Inc · Brawley, CABuilt 1975 · S/N E-789N6098NRegistered aircraftBuilt 1968 · S/N MB-395N60AB4 Girls Aircraft LLC · Wilmington, DEBuilt 1977 · S/N P-432N60AMCleveland Flying Inc · Cleveland, MSS/N CE-764N60AULife'S A Beech LLC · Sun Prairie, WIFirst renewal noticeS/N TE-915N60CLJubjub LLC · Shawnee, KSBuilt 1972 · S/N P-201N60DRSudeep Singh Flllp · Clovis, CABuilt 1978 · S/N E-1214N60EDKamal Ronny · Chicago, ILBuilt 1985 · S/N E-2241
Back to AD 99-05-13 R1 WD