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.

N6505JWedel Dan P · Fairmont, MNBuilt 1968 · S/N 28-4941N6505WOndracek Jack E · Port Orchard, WABuilt 1964 · S/N 28-20582N6506WRoehrig Michael A · Fairport, NYBuilt 1965 · S/N 28-20583N6509JRoot Rickey · Nederland, TXBuilt 1968 · S/N 28-4945N650FLHarps Thomas B · Vilonia, ARBuilt 1971 · S/N 28-7125559N6510JSabin Michael J · Virginia Beach, VABuilt 1968 · S/N 28-4946N6511JCalhoun John R · Baton Rouge, LABuilt 1968 · S/N 28-4948N6511WWinkler Frank · Joplin, MOS/N 28-20589N6512JDion Nelson · Cromwell, CTBuilt 1968 · S/N 28-4949N6512WBirrer Urs P · Huntington Beach, CABuilt 1965 · S/N 28-20590N6513JAlexander Sam L · Fair Play, MOBuilt 1968 · S/N 28-4950N6513WBuss Dillon W · Pryor, OKBuilt 1965 · S/N 28-20591N6514WDickey Jacob L · Sandy, UTBuilt 1964 · S/N 28-20592N6515WFrank Eric C · Frankfort, INBuilt 1964 · S/N 28-20593N6516JTeresurv Corp · Port Saint Lucie, FLBuilt 1968 · S/N 28-4953N6516WWalker Clint H · Tyler, TXBuilt 1965 · S/N 28-20594N6517JSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28-4954N6518WWedmore Catherine A · Wellington, FLBuilt 1965 · S/N 28-21265N6519WFalcon Aircraft Services Inc · Rockford, ILBuilt 1964 · S/N 28-20598N651FLGillam Charlene · Akron, OHBuilt 1971 · S/N 28-7125563N6520WP T Arts LLC · Grand Rapids, MIBuilt 1965 · S/N 28-20599N6521WEgert James R · Piedmont, OKBuilt 1965 · S/N 28-20600N6522JAbbott Aircraft Sales And Service LLC · Jefferson City, MOBuilt 1968 · S/N 28-4960N6522WLopienski Stephen · Selkirk, NYBuilt 1965 · S/N 28-20601N6523JCorona Air Paint LLC · Corona, CABuilt 1968 · S/N 28-4961N6523WCroft John Curtis · Princeton, KYBuilt 1965 · S/N 28-20602N6524WKoss Ronald P · Mckean, PABuilt 1965 · S/N 28-20603N6525WJackson Donald W · Carthage, MSBuilt 1964 · S/N 28-20604N6526JMcfeeters Milena · Madison, WIBuilt 1968 · S/N 28-4964N6527JHaverporth Daniel L · Las Cruces, NMBuilt 1968 · S/N 28-4965N6527WEnsminger Joseph · Manchester, MOBuilt 1965 · S/N 28-20606N6528WCampbell Joshua S · Sugarcrk Twp, OHBuilt 1964 · S/N 28-20607N6530JSalmon Woody W · Chalkyitsik, AKBuilt 1968 · S/N 28-4969N6531JLoehrer Daniel J · Milbank, SDBuilt 1968 · S/N 28-4970N6533JPaulson James L · Lawrenceville, NJBuilt 1968 · S/N 28-4973N6533W21 Luna LLC · Phoenix, AZBuilt 1965 · S/N 28-20612N6536JCooper David M · Sedona, AZS/N 28-4977N6536WDenny David F · Bath, NCS/N 28-20615N6537JTimer Anna Mae · Wildwood Crest, NJBuilt 1968 · S/N 28-4978N6538JBerra Robert J · Burtonsville, MDS/N 28-4980N6539WYounglove Donald L · Mendota, ILBuilt 1965 · S/N 28-20618N653BQQuilty Stephen M · Abingdon, VABuilt 1968 · S/N 28-5055N6540WRiggs Charles A · Pembroke Pines, FLBuilt 1965 · S/N 28-21266N6542WBaird Philip D · Judith Gap, MTS/N 28-21268N6543WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-20622N6547JMeyer Mark A · Vass, NCBuilt 1968 · S/N 28-4990N6547WMacclements Jonathan E · Austin, TXBuilt 1965 · S/N 28-20626N6548JInspire Aviation LLC · Magnolia, TXBuilt 1968 · S/N 28-4992N6549JHuff Glenn N · Hackettstown, NJFirst renewal noticeBuilt 1968 · S/N 28-4993N654BCCobb Charles J · Fallbrook, CABuilt 1969 · S/N 28-5335
Back to AD 96-10-01 R1