OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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.

N5864FSkaw Jack E · New Auburn, WIBuilt 1967 · S/N 21058864N5864GScarabin Jim D · Apalachicola, FLBuilt 1969 · S/N 15071364N5864RBattle Proven Leadership LLC · Crown Point, INBuilt 1965 · S/N 17253533N58650Orwosky Jeff · Sulphur Springs, TXBuilt 1973 · S/N 18262205N58652K L Aircraft LLC · Fort Myers, FLBuilt 1973 · S/N 18262206N58653Rydman Nathan D · Moab, UTBuilt 1973 · S/N 18262207N58658Witte Thomas L · Palestine, TXBuilt 1973 · S/N 18262212N58659Friis Karsten · Oxford, NCBuilt 1973 · S/N 18262213N58662Vomsaal Frederick S · Columbia, MOBuilt 1973 · S/N 18262216N58664Hamby Eileen R · Scottsboro, ALBuilt 1973 · S/N 18262218N58666Brewer Loyd N · Santa Maria, CABuilt 1973 · S/N 18262220N5866AChipman Jeffrey M · Rising Sun, INS/N 28466N5866BAir-O-Drome Aviation LLC · Caldwell, IDBuilt 1956 · S/N 33866N5866RNeal Edward K · Laud By Sea, FLS/N 17253535N58673Nawrocki Daniel N · Fairmont, WVBuilt 1973 · S/N 18262226N5867AUrciuoli Salvatore · Holbrook, NYBuilt 1956 · S/N 28467N5867CGunnarsson Jon · Concrete, WABuilt 1970 · S/N 15072277N5867FIndigo Of South Fl Inc · Sunrise, FLS/N 21058867N5867GCrowley Kelly P · Mount Pleasant, SCBuilt 1969 · S/N 15071367N5867RGoatley John E · Springfield, KYS/N 17253536N58689Reinheimer Robert W · San Francisco, CABuilt 1973 · S/N 18262237N5868MMack Michael J · Loomis, CABuilt 1977 · S/N 18266083N5868RRizzo John M Sr · Sugar Land, TXBuilt 1965 · S/N 17253537N58691Sonday Terrance P · Spring, TXBuilt 1973 · S/N 18262239N58693Rychner Glen H · Deer River, MNBuilt 1973 · S/N 18262241N5869AHurt Wally · Amboy, WABuilt 1956 · S/N 28469N5869BGoodman David · Yuba City, CAS/N 33869N5869FCavanaugh Gerald R · Friendswood, TXBuilt 1967 · S/N 21058869N586RJThayer Terry · Lafayette, INBuilt 1981 · S/N 18267860N586SRice James L · Mckinney, TXBuilt 1981 · S/N 17274646N58701Elsik Dewey D · Georgetown, TXBuilt 1973 · S/N 18262246N58707Takallu M A · Norfolk, VABuilt 1973 · S/N 18262248N5870AGlenn Chester L · Hugo, OKBuilt 1956 · S/N 28470N5870BSkylane 70b LLC · Pine, COBuilt 1956 · S/N 33870N58714Fun Flying LLC · Wadsworth, OHBuilt 1973 · S/N 18262253N5871CN5871c LLC · Boulder, COBuilt 1973 · S/N 18262251N5872FStearns Edwin B Jr · Chandler, AZBuilt 1967 · S/N 21058872N5872GCramer John A · Marana, AZBuilt 1969 · S/N 15071372N5872RMckee Joseph R · Godfrey, ILBuilt 1965 · S/N 17253541N58739Josey Lumber Co Inc · Scotland Neck, NCBuilt 1973 · S/N 18262268N5873AWilemon Stephen L · Tulsa, OKBuilt 1956 · S/N 28473N5873FWehrman George · Covina, CABuilt 1967 · S/N 21058873N5873R3 Points LLC · Comstock Park, MIBuilt 1965 · S/N 17253542N58742Vaughn Michael R · Summersville, MOBuilt 1973 · S/N 18262269N58747Martin Robert Daniel · Little Rock, ARBuilt 1973 · S/N 18262272N5874AShaha Zachary D · Menomonie, WIBuilt 1956 · S/N 28474N5874BTravis Clay · Hopkinsville, KYBuilt 1956 · S/N 33874N5874RHammel Tyler S · Dufur, ORBuilt 1965 · S/N 17253543N5875ARoberts Dallon W · Kamiah, IDS/N 28475N5875BFerguson Bruce W · Fort Peck, MTBuilt 1956 · S/N 33875
Back to AD 87-20-03 R2