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.

N7224FBiviano Joseph J · Tehachapi, CAS/N 28-25136N7225WOshaughnessy Breandan · Allen, TXBuilt 1963 · S/N 28-1041N7226JChristffersen Robert H · Tacoma, WABuilt 1968 · S/N 28-24562N7226WStuart Ryan C · Snowflake, AZBuilt 1963 · S/N 28-1143N7227FStrange Keith · Lincoln, MEBuilt 1968 · S/N 28-25139N7227JRad Aviation LLC · Abbeville, ALS/N 28-24563N7228JRedhanded LLC · Dover, DEBuilt 1968 · S/N 28-24564N7229JLivingston Corey · Myrtle Beach, SCBuilt 1968 · S/N 28-24565N7229WRoll The Bones LLC · Kiln, MSBuilt 1963 · S/N 28-1046N722FLShaughnessy Thomas E · Seabrook, NHS/N 28-7225404N7230FBenautics LLC · Wexford, PABuilt 1968 · S/N 28-25143N7230JBrewer Michael S · New Haven, WVBuilt 1968 · S/N 28-24566N7231JMcflight Aviation LLC · Highland, UTBuilt 1968 · S/N 28-24567N7232JEllero John L · Sun City, CABuilt 1968 · S/N 28-24568N7232WAwmr LLC · Conroe, TXBuilt 1963 · S/N 28-1050N7233JPinnick Andrew · Beckley, WVBuilt 1968 · S/N 28-24570N7234WMoco Aviation LLC · Moultonborough, NHBuilt 1963 · S/N 28-1053N7235WMorris George · Redlands, CABuilt 1963 · S/N 28-1054N7236FRegistered aircraftBuilt 1968 · S/N 28-25148N7236JBackman Randy L · Bellingham, WAS/N 28-24573N7237WPetropulos James J · Juneau, AKBuilt 1963 · S/N 28-1056N7238FDoll William J · Carlisle, PABuilt 1968 · S/N 28-25150N7238WRupert Shon D · Greenwood, ARBuilt 1963 · S/N 28-1057N7239WWiza Jason · Custer, WIBuilt 1963 · S/N 28-1059N723PMCeu LLC · Greer, SCBuilt 1967 · S/N 28-4329N7240FDewberry Dylan C · Springfield, ORBuilt 1968 · S/N 28-25153N7240JFlytt LLC · Naples, FLBuilt 1968 · S/N 28-24577N7241CHeritage Timothy D · Glendale, AZBuilt 1975 · S/N 28-7625073N7241JHopkins Justin C · Benson, AZFirst renewal noticeS/N 28-24578N7241WBurtchett Tyler D · Buckeye, AZBuilt 1963 · S/N 28-1075N7242FDjair · Winchester, VAS/N 28-25155N7242WSouthwest Fluid Products Inc · Weatherford, TXS/N 28-1065N7243FBlack Diamond Real Estate · Roseville, CABuilt 1968 · S/N 28-25159N7243JNova Flight LLC · Gainesville, VABuilt 1968 · S/N 28-24583N7243WLejeune Ovey Eugene · Roanoke Rapids, NCBuilt 1963 · S/N 28-1066N7245FLeinart Brannon B · Merit, TXBuilt 1968 · S/N 28-25161N7245JKallen David A · Northville, NYBuilt 1968 · S/N 28-24586N7246JCooper Christopher B · Crowley, TXBuilt 1968 · S/N 28-24587N7249FAndrews Josh S · Warsaw, MOBuilt 1968 · S/N 28-25166N7249JJohnson Dale F · Marion, INBuilt 1968 · S/N 28-24591N724FLUncle Tommy LLC · Aurora, ILBuilt 1972 · S/N 28-7225417N724LPBone Aviation LLC · Calhoun, GABuilt 1968 · S/N 28-4962N7250JBrandenburg Carl A Jr · Goodyear, AZBuilt 1968 · S/N 28-24592N7250WHuber Peter Michael · Pulaski, VABuilt 1963 · S/N 28-1078N7251FWright Charles W · Selbyville, DEBuilt 1968 · S/N 28-25168N7251JChapman Michael S · Cardington, OHBuilt 1968 · S/N 28-24593N7252JMedina Jose · Spring, TXBuilt 1968 · S/N 28-24594N7253JLeffler William J · Tucson, AZBuilt 1968 · S/N 28-24595N7253WGross Matthew A · Ridgecrest, CABuilt 1963 · S/N 28-1081N7254FWolf Kim A · East Wenatchee, WAS/N 28-25172
Back to AD 96-10-01 R1