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.

N7530VNicolaou John G · San Ramon, CABuilt 1976 · S/N 177RG0827N7531NDreampad LLC · New York, NYBuilt 1974 · S/N 18263233N7531TJanke Gregory A · Lompoc, CABuilt 1959 · S/N 47131N7532NEagle Air LLC · Morgantown, WVBuilt 1977 · S/N U20603664N7532TVan Voast Carla J · Turner, MTBuilt 1959 · S/N 47132N7532XRoy John L · Edmonds, WABuilt 1960 · S/N 17248032N7533GSiess Tye G · Hot Springs, ARS/N 15074691N7533THansman Jon C · Ashland, WIFirst renewal noticeBuilt 1959 · S/N 47133N7533VWilliams Jeffrey D · Sparta, NJBuilt 1976 · S/N 177RG0830N7533XRegistration Pending · Lincoln, NDRegistration pendingBuilt 1960 · S/N 17248033N7534MChapman Maxwell A · Menasha, WIBuilt 1959 · S/N 55834N7534TFreudenthal Timothy M · Wautoma, WIBuilt 1959 · S/N 47134N7534VCardinal Aero Group LLC · Marshall, ARBuilt 1976 · S/N 177RG0831N7535MRegistered aircraftBuilt 1959 · S/N 55835N7535TStearman Matthew G · Andale, KSBuilt 1959 · S/N 47135N7535VSchneider Martin G · Milford, NES/N 177RG0832N7535XLilley Jeffery L · Buffalo, MOBuilt 1960 · S/N 17248035N7536MW R Aviation Inc · Stigler, OKBuilt 1959 · S/N 55836N7536NRomence Louis Wm · Grand Rapids, MIBuilt 1974 · S/N 18263237N7536TD&K Ag Service Inc · Lantry, SDS/N 47136N7536VBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 177RG0833N7537GConway John F · Cumming, GABuilt 1974 · S/N 18263321N7537MKnox Larry D · Parachute, COS/N 55837N7537VHorizon Aeronautics Inc · Columbia, SCBuilt 1976 · S/N 177RG0834N7538TClark Walter A Jr · Willcox, AZBuilt 1959 · S/N 47138N7538UHooper Lawrence S · Melba, IDBuilt 1975 · S/N 15077734N7538VLee Walker S · Searcy, ARBuilt 1976 · S/N 177RG0835N7538XSpratt John G · Watkinsville, GABuilt 1960 · S/N 17248038N7539MBungalow Drug Inc · Belgrade, MTBuilt 1959 · S/N 55839N7539NDavis Dale L · Boerne, TXBuilt 1977 · S/N U20603666N7539TCropper Kenneth B · Orangeville, UTBuilt 1959 · S/N 47139N7539UAirgo Inc · Centralia, ILS/N 15077735N7539XWalnut Valley Aviation LLC · Wilmington, DEBuilt 1960 · S/N 17248039N7540GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259240N7541TSmith Danny R · Sherman, TXBuilt 1959 · S/N 47141N7541XRegistered aircraftBuilt 1960 · S/N 17248041N7542GNelson Frank H · Tuscaloosa, ALBuilt 1970 · S/N 17259242N7542VCoastal Cosmetic And Implant Denistry LLC · Miramar Beach, FLBuilt 1976 · S/N 177RG0839N7543GTrue Course LLC · West Monroe, NYBuilt 1970 · S/N 17259243N7543MSwanson James E · O Fallon, MOFirst renewal noticeBuilt 1959 · S/N 55843N7543TBlakeney David B · Pocahontas, ARBuilt 1959 · S/N 47143N7543VN7543v LLC · Moore Haven, FLS/N R1722309N7544VGavazzo Victor Grille · Saint Peters, MOBuilt 1976 · S/N 177RG0841N7544XRobert S Williams Dds Ps · Grandview, WABuilt 1960 · S/N 17248044N7545MMurray Erwin L Jr DBA · Emporium, PABuilt 1959 · S/N 55845N7546MKress Carl M Jr · Newark, DEBuilt 1959 · S/N 55846N7547GMutter William D · Chelan, WABuilt 1970 · S/N 17259247N7547MMcgovern Stephen M · Beaver Falls, PABuilt 1959 · S/N 55847N7547THall William D · Homeworth, OHBuilt 1959 · S/N 47147N7547XArmitage Donald · New Derry, PABuilt 1960 · S/N 17248047
Back to AD 87-20-03 R2