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.

N9626JCharles James Blake · Stinnett, TXBuilt 1966 · S/N 28-3782N9627JTucker Aviation LLC · Hollister, MOBuilt 1966 · S/N 28-3783N9628JMarshall Air LLC · Albuquerque, NMS/N 28-3785N9629JBrown Korey Fetty · Macungie, PABuilt 1966 · S/N 28-3786N9629WRobbins Clyde · Golden, MSBuilt 1967 · S/N 28-23086N9630WNull Robert D · Lake Charles, LABuilt 1967 · S/N 28-23087N9631JMckibben Andrew D · Gilmanton Iw, NHBuilt 1966 · S/N 28-3788N9632JAirbrain Aviation Inc · Snellville, GABuilt 1966 · S/N 28-3789N9633WFladager Enterprises Inc · Peerless, MTBuilt 1967 · S/N 28-23090N9634WShinar Philip C · California City, CABuilt 1967 · S/N 28-23091N9635WGordon David · Long Branch, NJBuilt 1967 · S/N 28-23092N9636JPorter Julia N · Pflugerville, TXBuilt 1966 · S/N 28-3833N9638JPrince Jennifer R · Farr West, UTBuilt 1967 · S/N 28-3867N9639WUlmer Daniel J · Menno, SDBuilt 1967 · S/N 28-23097N9641JRegistration Pending · Fresno, CARegistration pendingS/N 28-3865N9641WHoover Anna L · Anchorage, AKBuilt 1967 · S/N 28-23100N9642JSafety First Flying · Murphysboro, ILS/N 28-3870N9642WN9642w Leasing LLC · Corunna, MIBuilt 1967 · S/N 28-23101N9643JHitchings Fred · Chesapeake, OHBuilt 1967 · S/N 28-3871N9643WN9643w LLC · Dover, DEBuilt 1967 · S/N 28-23102N9644JLeckliter Michael A · Murrieta, CABuilt 1966 · S/N 28-3808N9645JLuxury Vacations Inc · Scottsdale, AZBuilt 1966 · S/N 28-3809N9646WOgier Gerard Paul · Hampton, NHBuilt 1967 · S/N 28-23105N9647JNelson Stephen A · Milaca, MNS/N 28-3873N9647WAirplanes Plus Inc · Marathon, FLBuilt 1967 · S/N 28-23106N9648WMccullough Dwayne D · Onancock, VABuilt 1967 · S/N 28-23107N9649JRegistration Pending · Springboro, OHRegistration pendingBuilt 1967 · S/N 28-3876N9649WWard Travis E · Tucson, AZBuilt 1967 · S/N 28-23109N9650JPalmer Eric · Bowling Green, OHBuilt 1967 · S/N 28-3815N9652WRegistered aircraftS/N 28-23112N9653JClear Sky LLC · La Grange Park, ILBuilt 1966 · S/N 28-3818N9653WWohl Scott D · Clarkston, WABuilt 1967 · S/N 28-23114N9654JMouton Charles J Jr · Gladewater, TXBuilt 1966 · S/N 28-3820N9655JDunn James Blair Jr · Bumpass, VABuilt 1966 · S/N 28-3822N9656JVolpe Robert · Holiday, FLBuilt 1966 · S/N 28-3823N9657WNorth Stephen P · Rochester, NYBuilt 1967 · S/N 28-23119N9658WGraham Joel A · Marietta, GABuilt 1967 · S/N 28-23120N9659WMitchell Matthew · Ypsilanti, MIBuilt 1967 · S/N 28-23121N9660WAlaimo Thomas J · Napa, CABuilt 1967 · S/N 28-23122N9661JGrant Michael T · Eugene, ORBuilt 1966 · S/N 28-3829N9663JN9663j LLC · Dallas, TXBuilt 1967 · S/N 28-3877N9665JUmbarger Brian T · Shawnee, KSBuilt 1966 · S/N 28-3834N9665WSoto Osvaldo · Myersville, MDBuilt 1967 · S/N 28-23129N9667JKidd James Allen · Owasso, OKBuilt 1967 · S/N 28-3836N9668JBullitt Melissa G · Glenmora, LABuilt 1967 · S/N 28-3837N9670WMoore Nicholas · Cedar Park, TXBuilt 1967 · S/N 28-23134N9671JElite Aircraft LLC · Bend, ORBuilt 1967 · S/N 28-3841N9672JRoger Dodger Vector Victor LLC · Fort Myers, FLBuilt 1967 · S/N 28-3842N9673JTamke Jon A · Battle Lake, MNS/N 28-3843N9676JOligario Jeremiah J · Fayetteville, NCBuilt 1967 · S/N 28-3846
Back to AD 96-10-01 R1