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.

N4292JReds Aircraft LLC · Edinburg, TXBuilt 1967 · S/N 28-22660N4293JCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1967 · S/N 28-22661N4294JWahner Rudolf M Jr Trustee · Aston, PAS/N 28-22663N4294TSopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1971 · S/N 28-7205134N429EGCongalton Steve M · Rancho Cucamonga, CABuilt 1974 · S/N 28-7405188N42KANorth Little Rock Air Inc · North Little Rock, ARBuilt 1966 · S/N 28-3702N4300TPei-Ning Lo · Rowland Heights, CABuilt 1971 · S/N 28-7225128N4301JHarris Matthew P · Batavia, NYBuilt 1967 · S/N 28-22671N4301XDestination 55 LLC · Cave Springs, ARBuilt 1975 · S/N 28-7625008N4303JGroff Paul F · San Leandro, CABuilt 1967 · S/N 28-22674N4303TReem Steven J · Cogan Station, PABuilt 1971 · S/N 28-7225129N43044Will Eric S · Waseca, MNBuilt 1974 · S/N 28-7405170N4304JStetser Nicholas R · Redding, CAS/N 28-22675N4304TButler Jeffrey C · Abilene, TXBuilt 1971 · S/N 28-7225131N4305JThompson Judith P · Loleta, CABuilt 1967 · S/N 28-22676N4305XKrzykwa Thomas F · Newark, DEBuilt 1975 · S/N 28-7625009N4307XHorizon Aviation LLC · Brooks, GABuilt 1975 · S/N 28-7505255N43088Registration Pending · Babson Park, FLRegistration pendingBuilt 1974 · S/N 28-7425333N4308JBuresh George W · Milwaukee, WIBuilt 1967 · S/N 28-22680N43098Forest City Aviation Inc · Forest City, IABuilt 1974 · S/N 28-7405175N43099Bennick Frances E · Andreas, PABuilt 1974 · S/N 28-7405176N4309JHorn Rodney L · Friendswood, TXBuilt 1967 · S/N 28-22681N4311JWalk Eugene P Jr · Barnegat, NJBuilt 1967 · S/N 28-22684N4311TChandler Air Service Inc · Chandler, AZBuilt 1971 · S/N 28-7225134N43126Bdc 43126 LLC · Dumfries, VABuilt 1974 · S/N 28-7405177N4312TByron James D · Houston, TXBuilt 1971 · S/N 28-7225135N4313JPaul Eric S · Diamond Bar, CAS/N 28-22686N4314JKoch Rodney W · Danville, INBuilt 1967 · S/N 28-22688N4314TMcdaniel Jay · Fairborn, OHBuilt 1971 · S/N 28-7205140N43151Neat Dihedral Aviation LLC · Loveland, COBuilt 1974 · S/N 28-7405178N43154Xavier Rafael O · Dallas, TXBuilt 1974 · S/N 28-7425339N43164Jasper Thomas Wesley · Monroe, NCBuilt 1974 · S/N 28-7425340N4316JAnderson Richard E · Indianapolis, INBuilt 1967 · S/N 28-22690N4317JMiller Anthony J · Rexford, MTBuilt 1967 · S/N 28-22691N431FDahlin Joel R · Saint Paul, MNBuilt 1968 · S/N 28-24929N43200Robertson Charles V II · Amarillo, TXFirst renewal noticeBuilt 1974 · S/N 28-7425344N4320JHaddle Eddie · Lindon, UTBuilt 1967 · S/N 28-22694N43218On Final Aviation LLC · Brookland, ARBuilt 1974 · S/N 28-7425345N4321JN51343 LLC · Newnan, GABuilt 1967 · S/N 28-22695N43221Bednarz Joseph P · Hendersonville, TNBuilt 1974 · S/N 28-7405181N43224Piper Aviation LLC · Tierra Verde, FLBuilt 1974 · S/N 28-7425346N4322JDougherty Joseph P · Hughesville, PABuilt 1967 · S/N 28-22696N43240O'Quinn Kayla M · Jesup, GABuilt 1974 · S/N 28-7405182N43241Atmospheric Vehicle & Spacecraft Flight Exploratio · Rch Palos Vrd, CAS/N 28-7425349N4324JStaple K Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 28-22699N43257P23 LLC · Edmond, OKBuilt 1974 · S/N 28-7405183N4325JJpsc LLC · College Station, TXBuilt 1967 · S/N 28-22700N4325TBledsoe Randell W · Springtown, TXBuilt 1971 · S/N 28-7205141N4326JHayes Barrett W · Siler City, NCBuilt 1967 · S/N 28-22701N4328JWeldon Thomas · Marysville, OHBuilt 1967 · S/N 28-22703
Back to AD 96-10-01 R1