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.

N95450Piper Aire LLC · Shell Knob, MOBuilt 1969 · S/N 28-25963N95452Blatti Charles A Jr · Elwood, ILBuilt 1969 · S/N 28-25965N95454Butler Byron D · Acworth, GABuilt 1969 · S/N 28-25968N95455Juszkiewicz Jack · El Paso, TXBuilt 1969 · S/N 28-25969N95457Miss May Aviation Inc · Brookfield, MABuilt 1969 · S/N 28-25967N95459Folsom James · Lawrenceburg, KYBuilt 1969 · S/N 28-25970N9545WBouthillier Mark W · Tonawanda, NYBuilt 1967 · S/N 28-22976N95461Bradford Murvin L · Hensley, ARS/N 28-25971N95463Licata Paul Z · Mexico, MOBuilt 1969 · S/N 28-25704N9546WSale Reported · Van Nuys, CASale reportedBuilt 1967 · S/N 28-22978N95471Herrington Herbert A · Gallatin, TNBuilt 1969 · S/N 28-25452N95473Bohling Anthony W · Auburn, NEBuilt 1969 · S/N 28-25981N95476Bollinger Aaron · Norfolk, VABuilt 1969 · S/N 28-25985N95477Wills Thomas J · Plainfield, ILBuilt 1969 · S/N 28-25986N95479Wilson Scott E · Fostoria, OHBuilt 1969 · S/N 28-25988N9547JFranz Stanley · Yakima, WABuilt 1966 · S/N 28-3676N95481North Texas Aeronautics LLC · Fort Worth, TXBuilt 1969 · S/N 28-25989N9548JMulder Timothy D · Shafter, CABuilt 1966 · S/N 28-3677N9550JRodriguez Gerald · West Hempstead, NYBuilt 1966 · S/N 28-3680N9551JKemp Richard · Manassas, VABuilt 1966 · S/N 28-3681N9552JStrong Dennis L · Minocqua, WIBuilt 1966 · S/N 28-3682N9553JStanley James C · Farmington, NMBuilt 1966 · S/N 28-3683N9553WRich Harold W · Fort Worth, TXBuilt 1967 · S/N 28-22989N9555JPaper Airplane Club LLC · Hillsdale, MIBuilt 1966 · S/N 28-3685N9556WMathison John M · Fernley, NVS/N 28-22993N9557WBowles Dan S · Wichita, KSBuilt 1967 · S/N 28-22994N9559WRickman Kevin A · Brownville, NYBuilt 1967 · S/N 28-22996N955DDRegistration Pending · Fort Wayne, INRegistration pendingBuilt 1977 · S/N 28-7725206N9560JAdams Carl J · Conroe, TXS/N 28-3691N9561JScarlet Aviation LLC · Jonestown, PAS/N 28-3692N9562JPosnett William L III · Lexington Park, MDBuilt 1966 · S/N 28-3697N9562WHub City Aviation Academy LLC · Lubbock, TXBuilt 1967 · S/N 28-22999N9563WEastside Development Co Inc · Winfield, KSBuilt 1967 · S/N 28-23000N9564JIrvin Stephanie Michelle · Jacksonville, FLBuilt 1966 · S/N 28-3699N9565JNebeker Kayla Rae · Murrieta, CABuilt 1966 · S/N 28-3700N9567WMiler Aaron L · Chambersburg, PABuilt 1967 · S/N 28-23005N9568WSale Reported · Cimarron, KSSale reportedBuilt 1967 · S/N 28-23006N9570JCharlie November Romeo LLC · Denver City, TXBuilt 1966 · S/N 28-3707N9571JMeunier Barry · Rehoboth, MABuilt 1966 · S/N 28-3708N9573WPyxl Sky LLC · Cogan Station, PABuilt 1967 · S/N 28-23013N9575JJones Anthony J · North Royalton, OHBuilt 1966 · S/N 28-3712N9575WMike Flying Service LLC · Terrell, TXBuilt 1967 · S/N 28-23015N9576JWright Jason C · Thorntown, INBuilt 1966 · S/N 28-3713N9577JBrown Dennis N · Bakersfield, CAS/N 28-3715N9578JDesbien Paul D · Texhoma, OKBuilt 1966 · S/N 28-3716N9579JGarrity Richard R · Green Bay, WIBuilt 1966 · S/N 28-3717N9580JFrontier Adventure Flyers LLC · Colorado Springs, COBuilt 1966 · S/N 28-3718N9580WDestination Flyer LLC · Memphis, TNBuilt 1967 · S/N 28-23025N9582WBlomquist Kevin C · Kanab, UTS/N 28-23027N9583JTevik Michael A · Provo, UTBuilt 1966 · S/N 28-3722
Back to AD 96-10-01 R1