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.

N43621Weade Ronald J · Wshngtn Ct Hs, OHBuilt 1974 · S/N 28-7405208N4362XSiegel Kurt · Denver, NCBuilt 1975 · S/N 28-7505259N4363JWoeste Joseph R · Sauk Centre, MNBuilt 1967 · S/N 28-22870N4364JDuffin Glenn R · Woodland Hills, UTBuilt 1967 · S/N 28-22743N4365JHofer Jeffrey · Lugoff, SCBuilt 1967 · S/N 28-22744N4366JRegistration Pending · Daytona Beach, FLRegistration pendingBuilt 1967 · S/N 28-22745N4370JDreyer Elwain C · Cardington, OHS/N 28-22754N4370XMcguirk Michael S · Johnstown, PABuilt 1975 · S/N 28-7625014N43721Penn Flight School LLC · Quakertown, PABuilt 1974 · S/N 28-7405215N4372XMurphy W Gary · Manitou, KYBuilt 1975 · S/N 28-7625022N4373JMiller Lillian N · Conyngham, PABuilt 1967 · S/N 28-22758N4373TMichelli Charles Wayne · Kingsport, TNBuilt 1972 · S/N E-13N4375FWings Aero LLC · Zeeland, MIS/N 28-7725012N4375TPillar Paul S · Lancaster, OHBuilt 1971 · S/N 28-7105231N4376JBlunt Jesse R · Winfield, MOBuilt 1967 · S/N 28-22761N4376TZara Aviation Corp · Chatsworth, CABuilt 1971 · S/N 28-7225157N4377TDemaria James L · Rockford, ILBuilt 1971 · S/N 28-7225158N4379JCouch Cody W · Louisa, VAS/N 28-22765N4379TLaw Matthew D · Hollis, NHBuilt 1972 · S/N 28-7205152N4380XEasterly Land And Cattle Inc · Sidney, NEBuilt 1975 · S/N 28-7625024N4381JPugh Robert Randall · Brewton, ALBuilt 1967 · S/N 28-22768N4382TGray Robert C · Dalton, MNBuilt 1971 · S/N 28-7205153N4384JBennett Nicholas C · England, ARBuilt 1967 · S/N 28-22771N4386JMeerwarth John J Jr · Eagle Bridge, NYS/N 28-22774N4386TTango 86 LLC · Stuart, FLBuilt 1971 · S/N 28-7105221N4387JSparetime Aviation LLC · Belle Plaine, MNBuilt 1967 · S/N 28-22775N4387TSkystat LLC · Forney, TXBuilt 1972 · S/N 28-7205155N4388JJohnson Kurt A · South Weber, UTS/N 28-22778N4388TClear Skies Aviation Inc · Montgomery, TXBuilt 1971 · S/N 28-7205156N4389FFarooqi Muhammad M · Plano, TXS/N 28-7725013N4389TBurchett James W · Seabeck, WABuilt 1972 · S/N 28-7205157N438FDFly Dynasty Corp · Ocala, FLBuilt 1967 · S/N 28-24061N4390JIsch Carl J · Geneva, INBuilt 1967 · S/N 28-22780N4391JAvian Leasing LLC · Bremerton, WABuilt 1967 · S/N 28-22781N4392JOrtega Rene · Seaside, ORBuilt 1967 · S/N 28-22783N4395JR W Dow Corp · Garrison, NYBuilt 1967 · S/N 28-22786N4396JSunshine Flight Services LLC · Dayton, TNBuilt 1967 · S/N 28-22788N4396TBanman David P · Seminole, TXS/N 28-7225162N4397JBeers Ward J · Shirleysburg, PABuilt 1967 · S/N 28-22789N4398JAberle Jerry L · Fallbrook, CAS/N 28-22790N43CSButler Bryan C · Brenham, TXBuilt 1968 · S/N 28-4641N4400JWright James R · Red Wing, MNBuilt 1967 · S/N 28-22793N44017Warrior Flyers Inc · Slinger, WIBuilt 1974 · S/N 28-7405217N4401JJohary Aviation Inc · Apopka, FLS/N 28-22794N44027Phelps Russell C · Naknek, AKBuilt 1974 · S/N 28-7425385N44037Choate Clint · Liberty Hill, TXBuilt 1974 · S/N 28-7405218N4403JColey Shane · Statham, GABuilt 1967 · S/N 28-22796N4404JFly Like A Girl LLC · Friday Harbor, WABuilt 1967 · S/N 28-22798N4405TDmac Aircraft LLC · Savannah, GABuilt 1972 · S/N 28-7205160N44066Majefski Waylon C · Kingwood, TXBuilt 1974 · S/N 28-7405219
Back to AD 96-10-01 R1