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.

N7223MMoosehead Enterprises LLC · Estero, FLBuilt 1958 · S/N 55523N7223NLee Stephen J · Cadiz, KYS/N 18263014N7223QBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260523N7223SSong David D · Ashland, CABuilt 1967 · S/N 15067923N7223TRoberts Michael R · Plano, TXBuilt 1959 · S/N 46823N7224EHowenstein John G · Roseville, CABuilt 1959 · S/N 52224N7224NCook Jon I · Cloudcroft, NMBuilt 1974 · S/N 18263015N72250Anderson Gilbert Lc · Palm Bay, FLS/N 33701548N7225AFouts Philip W · Caldwell, IDBuilt 1956 · S/N 29325N7225GVance Wilbur H III · Hershey, PABuilt 1970 · S/N 17258925N7225SAero States Aviation LLC · Owasso, OKBuilt 1967 · S/N 15067925N7225VConnecticut Aircraft Sales LLC · Manchester, CTBuilt 1977 · S/N 17270030N7226EKinnebrew John · Adkins, TXBuilt 1959 · S/N 52226N7226GHerlihy Douglas K II · Denville, NJBuilt 1970 · S/N 17258926N7226SN46132 Leasing LLC · Kalispell, MTBuilt 1967 · S/N 15067926N7226TCreasman Zane V · Arden, NCBuilt 1959 · S/N 46826N7226V226v LLC · Zachary, LABuilt 1977 · S/N R1722302N7227ANewman Christan C · Niota, TNBuilt 1956 · S/N 29327N7227GBeltz Richard D · Lehighton, PABuilt 1970 · S/N 17258927N7227QElite Air LLC · Tullahoma, TNBuilt 1972 · S/N 17260527N72285Cave Creek Organics LLC · Flagstaff, AZBuilt 1969 · S/N U206-1351N72288Roberts Matthew R · Idaho Falls, IDFirst renewal noticeBuilt 1969 · S/N U206-1353N7228APaine Jered J · Cashmere, WAFirst renewal noticeBuilt 1956 · S/N 29328N7228GFasking Dan · Stanford, ILS/N 17258928N7228MBarton Chris · Bedford, WYBuilt 1958 · S/N 55528N7228SMendoza William S · Antioch, CABuilt 1967 · S/N 15067928N7228XBrown Richard D · Woodward, OKBuilt 1961 · S/N 15059328N72298Ronald D Mcgill Farms Inc · Klamath Falls, ORS/N 33701556N7229ASale Reported · Belleville, ILSale reported, pending cancellationBuilt 1956 · S/N 29329N7229ECreighton Richard L · Cincinnati, OHBuilt 1959 · S/N 52229N7229QSwitzer Frank Jr · Port Allegany, PABuilt 1972 · S/N 17260529N7229TSmith Carl L · Vinita, OKS/N 46829N722AARobinson Charles F Jr · Portage, MIBuilt 1972 · S/N 17261274N722BASunshine Airplanes LLC · Chandler, AZBuilt 1971 · S/N 18260915N722BCNordberg Chad J · Moses Lake, WABuilt 1973 · S/N 18262051N722BSAnstrand Charles J · Boise, IDBuilt 1959 · S/N 52252N722EELipham William H · Odessa, TXBuilt 1965 · S/N 18256238N722ELBristow Bryan M · Albany, ORBuilt 1981 · S/N 21064332N722JC722jc LLC · Tyler, TXBuilt 1968 · S/N 18259489N722LAllen Steven C · Crittenden, KYBuilt 1976 · S/N 15078489N722PDW O Zangger And Son Inc · North Loup, NEBuilt 1976 · S/N 21059833N722RGTri Ag Supply Inc · Harvard, ILBuilt 1981 · S/N 18268099N722RRAncira Autos LLC · San Antonio, TXBuilt 1979 · S/N 21063651N722SJJackson Stephen L · Belvidere, ILBuilt 1976 · S/N U20603361N722TMHenry John W · San Jose, CABuilt 1968 · S/N 18259512N72306Usda Aphis Ppq · Edinburg, TXBuilt 1969 · S/N U206-1360N72309Orion Works Ltd · Denali Park, AKBuilt 1969 · S/N U206-1362N7230GMaples Kevin T · Pueblo, COS/N 17258930N7230MSpring-Air LLC · De Graff, OHBuilt 1958 · S/N 55530N7230QArcade Flying Club Inc · El Dorado Hills, CABuilt 1972 · S/N 17260530
Back to AD 87-20-03 R2