OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,139

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:96-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1')
  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.

N9765WShelby Gary J · Harleysville, PABuilt 1967 · S/N 28-23251N9766WYoung Justice P · Prairie Grove, ARS/N 28-23252N9767JMatta Aviation Services LLC · Junction City, KSBuilt 1967 · S/N 28-3963N9767WBrighton Flying Club LLC · Brighton, MIBuilt 1967 · S/N 28-23254N9768JOpp Prop Air LLC · Collierville, TNBuilt 1967 · S/N 28-3964N9768WEichner Cynthia A Loening · Tolland, CTBuilt 1967 · S/N 28-23255N9769JDubovtsev Mikhail · Wildwood, NJBuilt 1967 · S/N 28-3967N9770WRegistration Pending · Altus, OKRegistration pendingBuilt 1967 · S/N 28-23257N9771JBuzzard Roost Aviation LLC · Marble, NCBuilt 1967 · S/N 28-4009N9772WCow Dog Flyers LLC · Bozeman, MTBuilt 1967 · S/N 28-23259N9773J1st Flight LLC · Granby, COBuilt 1967 · S/N 28-3972N9776JVarman Michael J · Elwood, ILS/N 28-3975N9777JKunick Matthew · Belfair, WAS/N 28-3976N9777WWinthrop Michael F · Gainesville, VABuilt 1967 · S/N 28-23265N9778JGilroy Shawn J · Bremen, GABuilt 1967 · S/N 28-3977N9779WNovember Sierra Aviation LLC · Oneill, NES/N 28-23267N9780J824-24th St LLC · Greeley, COBuilt 1967 · S/N 28-3979N9780WRosales Daniel M · Fairbanks, AKBuilt 1967 · S/N 28-23269N9781JWild Wingdom LLC · Greenville, SCBuilt 1967 · S/N 28-3982N9782WWolfehagen Paul B · Phoenix, AZS/N 28-23271N9784JScott Richard · Hagaman, NYBuilt 1967 · S/N 28-3965N9785JWells Legacy Consultants LLC · Hickory Creek, TXBuilt 1967 · S/N 28-3986N9785WLattaye Silas F · Mamou, LAS/N 28-23275N9786WBarker Michael S · Stanford, KYBuilt 1967 · S/N 28-23277N9787JButter Valley Golf Port Inc · Barto, PABuilt 1967 · S/N 28-3988N9788WBrown Steven · Queen Creek, AZS/N 28-23280N9789JShaw E Carl · Hawkinsville, GABuilt 1967 · S/N 28-3990N9790JSheets Martin C · Fairmont, WVBuilt 1967 · S/N 28-3992N9790WZachmeyer Errol · Alexis, ILFirst renewal noticeBuilt 1967 · S/N 28-23282N9791JAndersen Joshua J · San Antonio, TXS/N 28-3993N9791WSmith Gregory H · Dacula, GABuilt 1967 · S/N 28-23284N9792WTowner Flying Club · Pelican Rapids, MNS/N 28-23285N9793WCurtis Dana C · Roanoke, VABuilt 1967 · S/N 28-23286N9794JSmith Patrick · Cary, ILBuilt 1967 · S/N 28-3997N9795WSims Glenn C · Kingman, AZBuilt 1967 · S/N 28-23289N9796JSchueneman Herbert Harry · Monterey, CABuilt 1967 · S/N 28-4010N9796WDale Robert W · Forney, TXBuilt 1967 · S/N 28-23290N9798JRoat Todd J · Rio, WIBuilt 1967 · S/N 28-4012N9799JN9799j Aviation LLC · Allen, TXBuilt 1967 · S/N 28-4006N9799WBranchizio Christopher · San Antonio, TXBuilt 1967 · S/N 28-23295N97ADCunningham David · Thomasville, NCBuilt 1967 · S/N 28-22666N98001Goltsos William · Barrington, RIBuilt 1969 · S/N 28-25991N98009Lebron Renard Luke Jr · Gulfport, MSBuilt 1969 · S/N 28-25994N9800WPiper Solutions LLC · Lakewood, NJBuilt 1967 · S/N 28-23296N98012Registration Pending · West Sacramento, CARegistration pendingBuilt 1969 · S/N 28-25995N98014Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 28-25998N98015Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25999N98017Blakeslee Vernon A Jr · Torrington, CTBuilt 1969 · S/N 28-26000N9801WNorth Little Rock Air Inc · North Little Rock, ARBuilt 1967 · S/N 28-23297N98021Wright Joseph R · Perry, GABuilt 1969 · S/N 28-26001
Back to AD 96-10-01 R1