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.

N7059TBrommer Roger A · Lino Lakes, MNBuilt 1959 · S/N 46659N705CGLewis Scott M · Youngstown, OHBuilt 1978 · S/N R18200801N705RStatewide Contract Services LLC · Lowell, ORBuilt 1986 · S/N R-18202037N705TDFlight Gear Aviation LLC · Pickerington, OHS/N 15069561N706Old Aire LLC · Bellingham, WABuilt 1960 · S/N 50865N70607Walsh Dennis A · Dakota City, NEBuilt 1968 · S/N 18259323N70609Gospel Ministries International · Mc Donald, TNBuilt 1968 · S/N 18259325N7060AWalker Jonathan S · Council Bluffs, IABuilt 1956 · S/N 29160N7060EBrenner Valerian · Port Saint Lucie, FLBuilt 1960 · S/N 56560N7060QPilot In Command Academy Inc · Miami, FLBuilt 1972 · S/N 17260360N7060SDygas Pauel · Pomerene, AZS/N 15067760N70616Washburn Darlene J · Newberg, ORBuilt 1968 · S/N 18259326N70617Mcnutt John W · Seattle, WABuilt 1968 · S/N 18259327N70618Allen Steven P · Flagstaff, AZBuilt 1968 · S/N 18259328N7061QMccutcheon Henry C · Frankfort, KYBuilt 1972 · S/N 17260361N7061SDirar Farras S E · Sackets Harbor, NYBuilt 1967 · S/N 15067761N7062Carvagno Lawrence · Trinity, ALS/N 18260264N70625Resong Joseph J · Garden Grove, CABuilt 1968 · S/N 18259331N7062GNorthwoods Aviation LLC · Eagle River, WIS/N 17258762N7062MWieler Jay H · Nome, AKFirst renewal noticeBuilt 1958 · S/N 55362N7062SPrecision Aerospace Corp · Sarasota, FLBuilt 1967 · S/N 15067762N7062TJardd Inc · Lorain, OHBuilt 1959 · S/N 46662N70632Galion Air Inc · Galion, OHBuilt 1968 · S/N 18259332N70633North County Flying Club · Tehachapi, CAFirst renewal noticeBuilt 1968 · S/N 18259333N70634Sowry Myron E · Phillipsburg, OHBuilt 1968 · S/N 18259334N70635Sitatunga Springs LLC · River Hills, WIBuilt 1968 · S/N 18259335N7063ASexton Forest · Eagle Point, ORBuilt 1956 · S/N 29163N7063GL A H Eickhoff Farms Inc · Falls City, NEBuilt 1969 · S/N 17258763N7063QCarver Clarence K · Lutz, FLS/N 17260363N7063TMorris Coady C · Russell, KSS/N 46663N70649Carroll Aviation Inc · Carroll, IABuilt 1968 · S/N 18259341N7064ASelby Joshua F · Condon, ORBuilt 1956 · S/N 29164N7064EBolognese Joseph · Las Vegas, NVS/N 56564N7064SCuddington Mark E · Puyallup, WAS/N 15067764N70651Sale Reported · Lakewood, COSale reportedBuilt 1968 · S/N 18259342N70655Kusterer James E Jr · Nampa, IDBuilt 1968 · S/N 18259343N70657Cobra Kai Inc · Wichita Falls, TXBuilt 1968 · S/N 18259344N70658Vroom David H · Oro Valley, AZBuilt 1968 · S/N 18259345N7065AJahnke Michael D · Wichita, KSBuilt 1956 · S/N 29165N7065GAden David L · Keenesburg, COBuilt 1969 · S/N 17258765N7065JAmendt Inc · Sedgwick, COS/N 18257772N7065MPamair Inc · Wilmington, DEBuilt 1958 · S/N 55365N7065TRegistered aircraftBuilt 1959 · S/N 46665N7066ANewton Consulting & Engineering Inc · Tucson, AZBuilt 1956 · S/N 29166N7066EBarnes Stephen W · Mustang, OKBuilt 1960 · S/N 56566N7066FLamb Barry J · Moran, KSBuilt 1966 · S/N 15063666N7066GSwindle Don K · Collinsville, TXBuilt 1969 · S/N 17258766N7067AWhitemire Jospeh A · Soddy Daisy, TNBuilt 1956 · S/N 29167N7067BMcdonald John M · Lyons Falls, NYFirst renewal noticeBuilt 1973 · S/N 18052367N7067E5 Am Equipment LLC · Casper, WYBuilt 1960 · S/N 56567
Back to AD 87-20-03 R2