OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N23370Carruthers John H Jr · Berlin, NHBuilt 1968 · S/N 15068909N23372Dold Stephen E · Foresthill, CABuilt 1968 · S/N 15068911N23374Pannell Lucas J · Midland City, ALBuilt 1968 · S/N 15068913N2337DSurely You Cant Be An LLC · Albuquerque, NMBuilt 1952 · S/N 20489N2337SMoore John A · Ada, MIBuilt 1967 · S/N 337-0637N23382Galster Scott · Oneonta, NYBuilt 1968 · S/N 15068918N23386Perta Steven J · Rome, NYBuilt 1968 · S/N 15068920N23387Strickland Kim A · Bowling Green, OHBuilt 1968 · S/N 15068921N2338FDonnell James C · Crowville, LABuilt 1964 · S/N 21058538N2338GIberlin Ranch · Gillette, WYBuilt 1958 · S/N 51638N23390Smp LLC · Kenner, LAS/N 15068924N23391Porter Scott · Aguila, AZBuilt 1968 · S/N 15068925N23392Mullins Adrian · Cartersville, GABuilt 1968 · S/N 15068926N23398Murillo Anthony · Davis, CABuilt 1968 · S/N 15068928N2339CSullivan Nathan · Croton, OHS/N 30639N2339DWenrich Kevin P · Myerstown, PAS/N 20491N2339GWetzel William W · Carrizozo, NMBuilt 1958 · S/N 51639N2339RStephens Grant A · Palmer, AKBuilt 1964 · S/N 18255439N2339XPetet David G · Orofino, IDBuilt 1965 · S/N 18256239N2339YGross Barbara J · Timber Lake, SDS/N 17700139N233GSGreenville County Sheriffs Office · Greenville, SCBuilt 1972 · S/N 18261018N233MGFly Safe LLC · Belle Isle, FLBuilt 1980 · S/N R18201541N233SHSieger Aviation Services Inc · Bismarck, NDBuilt 1979 · S/N 15283714N233TCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17257920N233WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 18257879N233WRVenture Alaska LLC · Homer, AKS/N U20603574N2340CWilliam J Davis · Bismarck, NDS/N R18200155N2340GConner Chris L · Boise, IDS/N 51640N2340RBrandt Phillip A · Boyd, TXBuilt 1964 · S/N 18255440N2340UTex-Pan Aviation Inc · Amarillo, TXBuilt 1982 · S/N 21064779N2340WPienkos Kaz · Haskell, OKS/N 51743N2341CBear Trap Enterprises Inc · Caldwell, IDBuilt 1953 · S/N 30641N2341DWeniger Gregory M · Burrton, KSBuilt 1952 · S/N 20493N2341XYale LLC · Watford City, NDS/N 18256241N23421High Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15068938N23422Air Logistics Group LLC · Winston Salem, NCS/N 15068939N2342CHite Donald L · Mc Kinney, TXBuilt 1953 · S/N 30642N2342EWolf John J · Mooresville, NCBuilt 1978 · S/N 17271245N2342GBrodie James W · Lind, WABuilt 1959 · S/N 51642N2342RFrisco Enterprises Inc · Califon, NJBuilt 1964 · S/N 18255442N2342XKinsella Joseph R · Jackson, WYBuilt 1965 · S/N 18256242N23435Depinet Thomas E · Mount Gilead, OHS/N 15068944N23437603 Flight LLC · Nashua, NHBuilt 1968 · S/N 15068945N2343CStedman Bernard Warren · Anchorage, AKS/N 30643N2343DShannon Jon M · Conroe, TXBuilt 1952 · S/N 20495N2343FRegistration Pending · Wickenburg, AZRegistration pendingBuilt 1964 · S/N 21058543N23440American Sky Aviation LLC · Anna, TXBuilt 1968 · S/N 15068947N23443Henson Joseph A · Jasper, ALBuilt 1968 · S/N 15068949N23444Garrett Scott E DBA · Owensville, INBuilt 1968 · S/N 15068950N2344DGough William N · Vancouver, WAS/N 20496
Back to AD 87-20-03 R2