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.

N3630RLachance John A · Thompson, CTBuilt 1971 · S/N 28-7125375N3633RGrammar Adrian Gates · Geneva, NYBuilt 1970 · S/N 28-5728N3634RRatkovich Stephen · Prospect Heights, ILBuilt 1971 · S/N 28-7125140N3636KCronin John M · Bremerton, WABuilt 1967 · S/N 28-23662N3637RGelinger Gary · Cape Carteret, NCBuilt 1970 · S/N 28-5732N3638RDukeman James C · Apex, NCBuilt 1970 · S/N 28-5735N3641RGeorge Walker Field Inc · Bedminster, NJBuilt 1969 · S/N 28-5737N3644KDraheim Allan C · Lagrange, GABuilt 1967 · S/N 28-23663N3644RRegistration Pending · Sarasota, FLRegistration pendingBuilt 1969 · S/N 28-5742N3647KRayman Bethany A · Salem, SDS/N 28-23666N3647RRegistration Pending · Indianapolis, INRegistration pendingBuilt 1970 · S/N 28-5744N3648KBonanno John W · Oceanside, NYBuilt 1967 · S/N 28-23667N3649RCummings Jason M · San Rafael, CABuilt 1969 · S/N 28-5746N3650RScd Medical LLC · Alexandria, LABuilt 1969 · S/N 28-5747N3652RShales Rene J · Hampshire, ILBuilt 1969 · S/N 28-5756N3653RSingh Harsimran · Las Vegas, NVBuilt 1970 · S/N 28-5758N3654KBeaber Michael J · Fremont, OHBuilt 1967 · S/N 28-23673N3654RSierra Delta 1 LLC · Dover, DEBuilt 1969 · S/N 28-5759N3659KDumont Mark · Brush Prairie, WABuilt 1967 · S/N 28-23676N3659RInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-5762N3660RBackcountry Wings LLC · Gig Harbor, WABuilt 1970 · S/N 28-5764N3662RBevard Thomas E · Montross, VABuilt 1969 · S/N 28-5766N3667RShamrock Aviation LLC · Broken Bow, NEBuilt 1970 · S/N 28-5771N3668KPiston Aviation LLC · Saint Charles, MOBuilt 1967 · S/N 28-23678N3669RFulks Helicopter Service LLC · Norfolk, NEBuilt 1970 · S/N 28-5772N3670RPecht Brian J · Lewistown, PABuilt 1969 · S/N 28-5773N3671RRoberts Charlie E · Cleveland, GABuilt 1969 · S/N 28-5774N3672KEgbert Colton T · Fernley, NVFirst renewal noticeBuilt 1967 · S/N 28-23682N3676RRaider Aviation LLC · Lubbock, TXBuilt 1969 · S/N 28-5779N367LRLa Rotta Tony · Pembroke Pines, FLBuilt 1972 · S/N 28-7325044N3681RSood Manu · Southfield, MIBuilt 1970 · S/N 28-5783N3682RTaylor John Edw · Alvarado, TXBuilt 1969 · S/N 28-5784N3683RRegistered aircraftBuilt 1969 · S/N 28-5785N3684RCulbert Megan C · Woodbury, NJBuilt 1969 · S/N 28-5786N3685RRailey Dustin Ward · Broxton, GABuilt 1970 · S/N 28-5787N3686RNeal Matthhew Z · Mansfield, OHBuilt 1970 · S/N 28-5788N3688KFlying Trout LLC · Port Orchard, WAS/N 28-23688N3689RBdj Farms · Hallock, MNS/N 28-5733N3690KCrouch James Doyle Jr Trustee · Germantown, TNBuilt 1967 · S/N 28-23689N3690REagle Aero LLC · Clermont, FLBuilt 1970 · S/N 28-5715N3693RA Parrottes View In Flight LLC · Wilmington, DES/N 28-5213N3694RSippel Paula M · Webster, NYBuilt 1971 · S/N 28-7105135N3695RPeake Aviation LLC · Flint, MIBuilt 1969 · S/N 28-5400N36RBEngelmann Randal · West Palm Beach, FLBuilt 1966 · S/N 28-22384N3700KMathews Nancy M · Englewood, TNBuilt 1967 · S/N 28-23694N3701KCdm Atlanta Inc · Tyrone, GABuilt 1967 · S/N 28-23696N3701RScarpelli Jim · Wichita, KSBuilt 1970 · S/N 28-5393N3703RAlexandria Flying Club Inc · Alexandria, MNBuilt 1970 · S/N 28-5769N3706KRegistration Pending · Cedar City, UTRegistration pendingBuilt 1967 · S/N 28-23699N3710KBlack Dragon87 LLC · Milford, CTBuilt 1967 · S/N 28-23701
Back to AD 96-10-01 R1