OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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.

N92135Jackson Christopher Michael · Clearwater, FLBuilt 1979 · S/N 288090127N9213JRegistered aircraftBuilt 1966 · S/N 28-3283N9213KCarver Clarence K · Lutz, FLBuilt 1976 · S/N 28-7625170N9214JSale Reported · Hurdsfield, NDSale reported, pending cancellationBuilt 1966 · S/N 28-3284N9214WManning John · Oro Valley, AZBuilt 1967 · S/N 28-10878N9215DToga LLC · Cumming, GABuilt 1990 · S/N 3213037N9215JGrizzard Shawn C · Hayden, IDS/N 28-3285N9216JSantana Alexandre C · Long Beach, CABuilt 1966 · S/N 28-3286N9217JWaicekauskas Joe · Raymondville, MOBuilt 1966 · S/N 28-3287N9217KR & R Air Inc · Wilmington, DEBuilt 1976 · S/N 28-7615183N9217WMartin Joe T Jr · Chandler, AZBuilt 1967 · S/N 28-10882N9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1988 · S/N 2841022N9218RFishe Flying Corp · Vero Beach, FLBuilt 1988 · S/N 2841023N9218WRitcheson Mark F · Tucson, AZBuilt 1967 · S/N 28-10883N9219KJones Robert M · Brooksville, FLBuilt 1976 · S/N 28-7690229N921CBDavis David G · Cresson, TXFirst renewal noticeBuilt 1980 · S/N 32R-8129019N921JBC&Z Aero LLC · Des Plaines, ILBuilt 1976 · S/N 32R-7780099N921LCCrum Robert W · Lake Havasu City, AZBuilt 1969 · S/N 28-25939N921LJGossett Chase · Centre, ALBuilt 1977 · S/N 32R-7780449N921NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881885N921PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843268N9220BSchmalenberger Jason R · Hebron, NDBuilt 1993 · S/N 3213048N9220CDixon Aviation LLC · Oakland, MDBuilt 1978 · S/N 32-7840091N9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841030N9221JJgms Rose LLC · Stamford, CTBuilt 1966 · S/N 28-3291N9221WWadi-Ramahi Shadi J · Evansville, INBuilt 1967 · S/N 28-10889N9222QGood Shepherd Leasing Corp · Brooksville, FLBuilt 1993 · S/N 3213051N9222WJohnson Michael E · Tyler, TXS/N 28-10890N92239Kingdom Air LLC · Kalispell, MTBuilt 1993 · S/N 2811042N9223JRudo Mark R · Milton, DEBuilt 1966 · S/N 28-3293N9223WPierce Construction LLC · Shelby, ALBuilt 1967 · S/N 28-10891N9224JJackson Jonathan · Siloam Springs, ARBuilt 1966 · S/N 28-3294N9224NBlanchard Aviation LLC · Nazareth, PABuilt 1993 · S/N 3213054N9224WOppermann K Edward · Kingwood, TXBuilt 1967 · S/N 28-10892N9225CMeriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816447N9225NOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1989 · S/N 2841044N9225WMosley Marvin C · Buckley, WABuilt 1967 · S/N 28-10893N9226CLane Community College · Eugene, ORBuilt 1978 · S/N 28-7816448N9226KAlatis Nicholas C · Cincinnati, OHBuilt 1976 · S/N 32R-7680199N9227JBinns George E · Hackettstown, NJBuilt 1966 · S/N 28-3297N9227TGpa Aviation Club Inc · Wayne, NJBuilt 1985 · S/N 28-8511020N9228FWard Jack R · Simi Valley, CAS/N 32R7680197N9228JHail State Aviation LLC · Madison, MSBuilt 1993 · S/N 3213058N9228NEncore Jet Management LLC · San Antonio, TXBuilt 1993 · S/N 3213059N9229BSsb Holdings LLC · Lake Wales, FLBuilt 1993 · S/N 3213060N9229CNoble Land & Cattle Inc · Albion, NEBuilt 1978 · S/N 28-7890391N9229JUnterschuetz Phillip David · Ladysmith, WIBuilt 1966 · S/N 28-3299N9229WShackelford John S Jr · Roanoke, TXS/N 28-10897N922MJAga Aviation LLC · Woodruff, SCBuilt 1997 · S/N 3257004N92303Herman M Flink Inc · Mount Dora, FLBuilt 1993 · S/N 3213061
Back to AD 87-08-08 R3