OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N56951American Home Realty Services Inc · Lincoln, CAS/N 28R-7435062N56957Payne Glenn · Oregon, MOBuilt 1973 · S/N 28-7425070N56958Jackson Michael L · Nixa, MOFirst renewal noticeS/N 28-7425071N5695W95whiskey LLC · Georgetown, MABuilt 1963 · S/N 28-1070N56964Lafollette Larry E · Strafford, MOBuilt 1973 · S/N 28-7405052N56965Brazos River Aviation LLC · Plainview, TXBuilt 1973 · S/N 28-7410036N56966West David A · Astoria, ORBuilt 1973 · S/N 28-7425067N56970Simoneau Todd · Sandown, NHS/N 28-7405039N56972Eby Aviation LLC · Duluth, GABuilt 1973 · S/N 28R-7435067N56973Baja Flyers Inc · San Diego, CABuilt 1973 · S/N 28-7410039N56976Tate Bird L Jr · Hammond, NYBuilt 1973 · S/N 28-7425075N56977Evans Holland L · Danielsville, GABuilt 1973 · S/N 28-7425076N56978Brindley James G · Collinsville, ALBuilt 1973 · S/N 28-7425077N5697VPray Aviation Dr · Augusta, KSS/N 28-7716203N56986Loya Armando · Whittier, CABuilt 1973 · S/N 28-7425079N56987Ravotti Air LLC · Leechburg, PABuilt 1973 · S/N 28-7415032N56988Hillerman Paul J · Vinita, OKBuilt 1973 · S/N 28-7415033N56989Kenny Zachary D · Herndon, VABuilt 1973 · S/N 28-7405040N5698UNorby David S · Gooding, IDS/N 28-26495N5698WBurkett Aviation LLC · Hampstead, NCBuilt 1963 · S/N 28-1094N56991Schneider Stephen C · Denton, TXBuilt 1973 · S/N 28R-7435070N56992Attebery Larry J · Caldwell, IDBuilt 1973 · S/N 28R-7435071N569932c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 28-7410040N56996Zarn Douglas J · Amboy, MNBuilt 1973 · S/N 28-7425080N56997Bibb John G · Paragould, ARBuilt 1973 · S/N 28-7425081N569FLN7396w LLC · Coeymans Hollow, NYS/N 28-7125413N56EB56 Eb Inc · Jacksonville, FLBuilt 1968 · S/N 28R30647N56EKQuailair LLC Trustee · MichelstadtS/N 2890145N56GSScott Daily Inc · Ash Flat, ARS/N 32R-7780097N56JMBusiness Aircraft Leasing Inc · Petersburg, ILBuilt 1979 · S/N 28R-7918178N56NAHampden Aviation Services Inc · Northampton, MABuilt 1979 · S/N 28-8016073N56PGElite Holdings Inc · Wilmington, DEBuilt 2001 · S/N 3257216N56WBTmr Aviation LLC · Fredericksburg, VAS/N 28-4470N57006Olsen Chad · Hendricks, MNBuilt 1973 · S/N 28-7415034N5700FTubbs Arthur R · Audubon, NJBuilt 1968 · S/N 28-24849N5700WViriyaphap Chattada · Birmingham, ALBuilt 1963 · S/N 28-1104N5701FKaspar Roger · Aurora, ILBuilt 1968 · S/N 28-24885N5701USouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1969 · S/N 28-26498N57020Kerschner Ira Henry · Cochranville, PABuilt 1973 · S/N 28-7425083N5702FKoza William J · Albert Lea, MNBuilt 1968 · S/N 28-24881N5702UEdwardsson Axel M · Waianae, HIBuilt 1969 · S/N 28-26499N5703UXcelleration Aviation Inc · Sarasota, FLBuilt 1969 · S/N 28-26500N5703WKelley Keith B · Forney, TXBuilt 1963 · S/N 28-1128N5704FJames Alfred F · Katy, TXBuilt 1968 · S/N 28-25015N5704UZephyr Air LLC · Hickory, NCS/N 28-26501N5705FWilkinson David E · Waleska, GABuilt 1968 · S/N 28-25016N5705VFalcon Aviation Inc · Clarence Center, NYBuilt 1977 · S/N 28-7790500N5705WSmart Avionics Inc · Marietta, PABuilt 1963 · S/N 28-1115N5706USaccento Anthony J · Binghamton, NYBuilt 1969 · S/N 28-26503N5706WShick Andrew C · Grand Junction, COS/N 28-1165
Back to AD 87-08-08 R3