OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,138

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.

N3955XPabon Eduardo A · Granada Hills, CABuilt 1975 · S/N 28-7505251N3956RSobczak Joseph E · Groveland, CABuilt 1970 · S/N 28-7105061N3957RHaushold Aviation LLC · Shelbyville, TNBuilt 1970 · S/N 28-7105062N3958KArias Benjamin H · Fort Stockton, TXBuilt 1967 · S/N 28-23837N3959KPuertola Pascual G · Cobb, CAS/N 28-23838N3959RBederov Alex · Redwood City, CABuilt 1970 · S/N 28-7105064N3959XCavanaugh Brian L · Manitowoc, WIBuilt 1975 · S/N 28-7625001N395LAZapel Theodore O · Colorado Springs, COBuilt 1967 · S/N 28-23836N395MTCubi Erik O · Chicopee, MABuilt 1967 · S/N 28-23834N3960KRegistration Pending · Roanoke, TXRegistration pendingBuilt 1967 · S/N 28-23839N3960RLong William R · Jackson, TNBuilt 1971 · S/N 28-7105065N3961RWhite Lightning 3961r LLC · Chandler, AZBuilt 1971 · S/N 28-7105066N3962KFolsom Lawrence E · Millington, MDBuilt 1967 · S/N 28-23842N3962RNifong James · Enterprise, ALBuilt 1971 · S/N 28-7105067N3964RPerrin Gregory R · Vail, AZBuilt 1971 · S/N 28-7105069N3965RRamsey Brian D · Van Nuys, CABuilt 1971 · S/N 28-7105070N3965XDevore Randall F · Prescott, IABuilt 1975 · S/N 28-7625002N3966RBless Edward L Trustee · Hollister, CABuilt 1971 · S/N 28-7105072N3967KLakes Area Aero LLC · Pelican Rapids, MNS/N 28-23851N3968KOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-23852N3969KGrollimund David J · Pendleton, INS/N 28-23853N3970RRegistration Pending · Portland, ORRegistration pendingBuilt 1971 · S/N 28-7105075N3971KRegistered aircraftBuilt 1968 · S/N 28-23856N3972KPeak William G Jr · Westview, KYBuilt 1967 · S/N 28-23857N3974RAuclair Bill T DBA · Winsted, CTBuilt 1971 · S/N 28-7105080N3975KGlissman Robert D · Mystic, CTBuilt 1967 · S/N 28-23861N3977RSusens Dennis W · Columbia Falls, MTBuilt 1971 · S/N 28-7105082N3979KGrams Terry · Smithville, MOBuilt 1967 · S/N 28-23866N3979RClinton Flying Service Inc · Clinton, NCBuilt 1971 · S/N 28-7105084N3980KStephen Reinhart Air LLC · Depew, NYBuilt 1967 · S/N 28-23867N3980RMayor Michael E · Union, KYS/N 28-7105085N3981KLenko David J · Smyrna, DEBuilt 1967 · S/N 28-23869N3982KElson Irving A · Rockville, MDBuilt 1967 · S/N 28-23871N3983KDetroit Piper Sales & Service Inc · Pontiac, MIRegistration revokedBuilt 1967 · S/N 28-23872N3984RThompson Jim R · Holdenville, OKBuilt 1971 · S/N 28-7105088N3985RRealm Group Transport Inc · Las Vegas, NVS/N 28-7105089N3987XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 28-7505253N3989KWeese John G · Fort Worth, TXS/N 28-23879N3989RTemple Barbara A · Canyon City, ORBuilt 1971 · S/N 28-7105093N3990KPavlicek Gordon · Dickinson, NDS/N 28-23881N3991KIsaacs Brandon · Homedale, IDBuilt 1967 · S/N 28-23882N3993RTappan John A · Prosper, TXBuilt 1971 · S/N 28-7105097N3995KKennedy Daniel P · Phoenix, AZS/N 28-23887N3996KO Conner Kevin E · Carrollton, TXBuilt 1967 · S/N 28-23888N3997KFly Around Alaska LLC · Palmer, AKS/N 28-23889N3999RPhillips Faye L · Sierra Vista, AZBuilt 1971 · S/N 28-7105104N399CEEddings Charles A · Sheridan, ORBuilt 1964 · S/N 28-20416N399JTGiannoulas Chris Paul · Federal Way, WAS/N 28-7425315N39ECSmith Adria A · Kingwood, TXBuilt 1968 · S/N 28-4985N39SDMbm Leasing LLC · Jacksonville, NCBuilt 1966 · S/N 28-3565
Back to AD 96-10-01 R1