OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N8449JSchaff James F · Gakona, AKBuilt 1967 · S/N 15066349N8449MCopper River Airmotive LLC · Copper Center, AKBuilt 1969 · S/N A1500149N8449SHollensbe Brant W · West Des Moines, IABuilt 1965 · S/N 18256549N844PTPatterson James M · Eagle, IDBuilt 1972 · S/N 17261129N84507Weston Marcia K · Palestine, TXBuilt 1973 · S/N 18261881N84508Goodwin Reginald J O · Clancy, MTBuilt 1973 · S/N 18261882N8450EWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17272205N8450LElghammer Garrott W · Niles, MIBuilt 1968 · S/N 17256650N8450MChoquette Marc J · Juneau, AKBuilt 1969 · S/N A1500150N8450UJust-Plane-Fun LLC · Searcy, ARBuilt 1964 · S/N 17252350N84510Levine Peter D · Bisbee, AZBuilt 1969 · S/N 17258503N84511Lands Brian Lee · Blacklick, OHBuilt 1969 · S/N 17258504N84515Abbott Sean N · South Paris, MES/N 17258507N84518Ropp Dennis A · Albany, ORS/N 17258509N8451MDelalat Shariar · San Diego, CABuilt 1970 · S/N A1500151N8451QRunway Three Aviation LLC · Kalispell, MTBuilt 1976 · S/N U20603309N8451TTop Hand Inc · Laurel, MTBuilt 1959 · S/N 52351N8451XHorn Jamie D · Spicewood, TXBuilt 1961 · S/N 17248951N8451ZHagelstein Ele C · Sanderson, TXBuilt 1963 · S/N 2050451N84529Eckert Philip · Paso Robles, CABuilt 1969 · S/N 17258512N8452LParr Terri M · Catlin, ILBuilt 1968 · S/N 17256652N8452MHigh Flight LLC · Mount Pleasant, SCS/N A1500152N8452THarris Jerry A · Nampa, IDBuilt 1959 · S/N 52352N8452UGibson Gregory I · Ivel, KYS/N 17252352N8452XLas Gaviotas 409 LLC · Safford, AZBuilt 1961 · S/N 17248952N84531Northumberland Flying Club Inc · Gansevoort, NYBuilt 1969 · S/N 17258513N8453GBelue Gaythan D · Rogersville, ALBuilt 1965 · S/N 15062553N8453MWard Charles B · Salcha, AKBuilt 1976 · S/N 18264608N8453SHarvey Paul E · Richmond, MES/N 18256553N8453TSheridan Keith · Ottawa, ILBuilt 1959 · S/N 52353N8453USappah Guy · Lusby, MDBuilt 1964 · S/N 17252353N84541Stack Kenneth J · Carnegie, PABuilt 1969 · S/N 17258516N84544Cruz Pedro · Tampa, FLBuilt 1969 · S/N 17258517N8454MSp Leasing LLC · San Jose, CABuilt 1976 · S/N 18264609N8454ZParker Larry C · Roswell, NMBuilt 1963 · S/N 205-0454N8455JBentz Jack E · Huntington, WVBuilt 1967 · S/N 15066355N8455LYoumans Ronald E · Baxley, GABuilt 1968 · S/N 17256655N8455SWhite Noah Jay · Prairie Du Chien, WIBuilt 1965 · S/N 18256555N8455TSpringer Joseph R · Culpeper, VABuilt 1959 · S/N 52355N8455UOverton James D · Midland, TXBuilt 1964 · S/N 17252355N8455XRandall Jason L · Altus, OKBuilt 1961 · S/N 17248955N84566Dulin Morgan L · Midland, TXBuilt 1969 · S/N 17258524N84567Hixson Steven Dee · Longview, WABuilt 1969 · S/N 17258525N84569Nielsen David R · Sarona, WIBuilt 1970 · S/N 17258526N8456GAerial Perspective Inc · Fullerton, CABuilt 1965 · S/N 15062556N8456JHam Russell W · Dike, TXBuilt 1967 · S/N 15066356N8456LCherryhill Aviation Inc · Freetown, INBuilt 1968 · S/N 17256656N8456QHappy Wings LLC · Erie, COBuilt 1978 · S/N 18503707N8456SPalmer Jay H · Baraboo, WIBuilt 1965 · S/N 18256556N8456ZOpus Aviation LLC · South Hero, VTBuilt 1963 · S/N 205-0456
Back to AD 87-20-03 R2