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.

N2294YHeathfield William T · Plymouth, MIFirst renewal noticeS/N 17700094N22956Thyfault Raymond E · Mattawan, MIS/N 15068643N2295JPloyhart Edwin J · Harwood, NDBuilt 1966 · S/N 15065495N2295RDuhl James R · Roseville, MNFirst renewal noticeBuilt 1969 · S/N T210-0445N2295WBraswell Jerrold W · Dillingham, AKBuilt 1978 · S/N 20700448N2295YHutto Azel James III · Lexington, SCBuilt 1967 · S/N 17700095N22963Swift John S · Santa Barbara, CAS/N 15068646N22964Straight Flight Aviation LLC · Goliad, TXS/N 17264079N2296RCelias Food Corp · Miami, FLS/N T210-0446N2296TRegistered aircraftS/N R18200021N22970Kingdom Air Corps · Sutton, AKBuilt 1968 · S/N 15068651N2297SRocketjet LLC · Incline Village, NVS/N R18201328N2297YKomulainen Daryl B · Clarksville, TNBuilt 1967 · S/N 17700097N22980Salt City Aviation LLC · Hutchinson, KSBuilt 1968 · S/N 15068656N22988Runyon James R · Entiat, WABuilt 1968 · S/N 15068664N2298DAgaliotis Paul E · San Martin, CABuilt 1952 · S/N 20450N2298GPerkins Larry L · Wildomar, CAS/N 51598N2298JRoth Mark E · Stevensville, MTBuilt 1966 · S/N 15065498N2298TT C Rocket LLC · Traverse City, MIBuilt 1977 · S/N R18200023N22990Peterson Curtis L · Smith Center, KSBuilt 1968 · S/N 15068665N22991Dan Munson Consulting Pllc · Seneca, SCBuilt 1968 · S/N 15068666N22998N22998 LLC · Middletown, DES/N 15068670N2299CMiller William C · Boise, IDBuilt 1959 · S/N 52334N2299GLewis Frank B · Meeteetse, WYBuilt 1958 · S/N 51599N2299JMclaughlin Edward T · Silverdale, WAS/N 15065499N2299RBaer Monte Wayne · Ronan, MTS/N T210-0449N2299TC And L Outfitters LLC · Everglades City, FLBuilt 1956 · S/N 32520N2299XSturgeon Keith A · Saginaw, TXS/N 337-0199N229ANCalifornia In Nice Inc · San Jose, CABuilt 1982 · S/N 17275587N229BADavila Associates · Dorado, PRBuilt 1975 · S/N 17265585N229CN229c LLC · Holt, MOFirst renewal noticeBuilt 1965 · S/N 18256129N229CSChicostate Aviation LLC · Wilmington, DEBuilt 1960 · S/N 52363N229DKKoerkenmeier James J · Carlyle, ILBuilt 1979 · S/N 15283544N229NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N 17271323N229WWMcgregor Daniel A · Denali Park, AKBuilt 1973 · S/N U20601807N22BZ8k Investments LLC Series Cessna 150 · Perryton, TXBuilt 1968 · S/N 15068198N22CRegistered aircraftBuilt 1958 · S/N 51007N22CBVollstedt Gregory Scott · Anchorage, AKBuilt 1973 · S/N 185-02188N22CFGame Equipment Services LLC · Midland, TXBuilt 1961 · S/N 18253217N22CMDavis Frederich K · Dunbar, PABuilt 1965 · S/N 337-0159N22CVMcginley Donald J · Port Orange, FLBuilt 1973 · S/N 21059974N22DECrawford Edgar A · Locust Grove, GABuilt 1970 · S/N 17259168N22DXHawk Daniel G · Cocoa, FLBuilt 1958 · S/N 51442N22EPRobinson Michael · Tucson, AZBuilt 1972 · S/N 21059773N22FBWilson Travis · Beaver Dam, KYS/N 21060634N22FGState Of California Department Of Fish And Game · Sacramento, CABuilt 1983 · S/N 18504407N22GCSkydive Ky LLC · Cecilia, KYBuilt 1953 · S/N 30532N22GPDunkelburg David L · Milton Freewater, ORBuilt 1963 · S/N 58202N22JNRegistered aircraftBuilt 1979 · S/N 172RG0215N22KMTorris Warren E · San Dimas, CABuilt 1973 · S/N 21060132
Back to AD 87-20-03 R2