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.

N7289QStenstrom Steven M · Scottsdale, AZBuilt 1973 · S/N 18262057N7289SHancock Deborah M · Hayes, VABuilt 1967 · S/N 15067989N7289TShepherd Gary D · Owosso, MIBuilt 1959 · S/N 46889N728EGGarner John · Springfield, MOBuilt 1977 · S/N 18265842N728KGCapsed LLC · Mojave, CABuilt 1979 · S/N 17272662N728LCHeath Richard · Raymondville, TXBuilt 1974 · S/N 15075773N728VPLkc Holdings Inc · Dover, DEBuilt 1978 · S/N 18503614N7290ARipp Fred G · Eagle River, AKBuilt 1956 · S/N 29390N7290EDiaz Mark A DBA · Madera, CAS/N 52290N7291AWarren Mark W · Arlington, WAS/N 29391N7291EBryant Daniel R · Brookland, ARBuilt 1959 · S/N 52291N7291GKuntz Jeffrey A · Covington, OHBuilt 1970 · S/N 17258991N7291MLee Brainard E · Everett, WABuilt 1958 · S/N 55591N7291NGrandkids Ranch LLC · Lewis, COBuilt 1974 · S/N 18263078N7291QCryder Michael J · Billings, MTBuilt 1973 · S/N 18262059N7291TThomas Charles A · Hockley, TXBuilt 1959 · S/N 46891N7291XWaterman David K · Temple City, CAS/N 15059391N7292EPorter Samantha · Las Vegas, NVBuilt 1959 · S/N 52292N7292GMarquette County Flying Club · Marquette, MIBuilt 1970 · S/N 17258992N7292QDevereaux Bruce O · Pewamo, MIBuilt 1972 · S/N 17260592N7292TObloy James J · Brunswick, OHBuilt 1959 · S/N 46892N7292XRasmussen Paul L · Walla Walla, WABuilt 1961 · S/N 15059392N7293QKiely Richard · Encampment, WYBuilt 1973 · S/N 18262060N7293SGraham John T · Phoenix, AZBuilt 1967 · S/N 15067993N7293TMccamant Angus J · Alohu, ORBuilt 1959 · S/N 46893N72947Greer Glenn M · Eugene, ORBuilt 1972 · S/N 18800947N7294APiston Aviation LLC · Saint Charles, MOBuilt 1956 · S/N 29394N7294SRapid Nursing Staff Inc · Farmington, NMS/N 18265092N7294TBurnett Albert Franklin · Lubbock, TXS/N 46894N7295GHessel Block Co Inc · Hessel, MIS/N 17258995N7295MLambert James · Fort Mohave, AZBuilt 1958 · S/N 55595N7295QKangas Lisa M · Fairbanks, AKS/N 17260595N7295SSpeedbird Ventures LLC · Driftwood, TXS/N 15067995N7296AStoup Lyndal K · Cordell, OKBuilt 1956 · S/N 29396N7296EChampion Richard B · Artesia, NMBuilt 1959 · S/N 52296N7296GWind Walker LLC · Tucson, AZS/N 17258996N7296MHurlburt Ronald V DBA · Durand, WIS/N 55596N7296QRich Aviation Services LLC · Fort Worth, TXBuilt 1972 · S/N 17260596N7296TTurner Clinton C · Springdale, ARBuilt 1959 · S/N 46896N7297AMyers Maxwell D · Salt Lake City, UTS/N 29397N7297GBraun Ralph H · Moreno Valley, CAS/N 15074638N7297MVivion Michael T · Bozeman, MTBuilt 1958 · S/N 55597N7297SBukkila Joan E · Savage, MNBuilt 1967 · S/N 15067997N7298NMoore James Jeffrey · Midlothian, TXFirst renewal noticeBuilt 1974 · S/N 18263085N7299MJahnke Eric F · West Palm Beach, FLRevoked, canceledBuilt 1958 · S/N 55599N7299NGonin Henri Louis · Elko, NVBuilt 1974 · S/N 18263086N7299QStout Oscar M · Brookshire, TXS/N 17260599N7299TOstrowski Sven E · Mullica Hill, NJBuilt 1959 · S/N 46899N7299XPecoy Edward D · Lyons, NYBuilt 1961 · S/N 15059399N729HPorter Wade R · Durham, CABuilt 1949 · S/N 19044
Back to AD 87-20-03 R2