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.

N654FLRoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDBuilt 1971 · S/N 28-7125569N654YRVet Air LLC · San Juan, PRBuilt 1964 · S/N 28-1867N6550JJans Stanley E · Dakota City, NEBuilt 1968 · S/N 28-4994N6551WThull Stanley B · Freeport, MNBuilt 1965 · S/N 28-20631N6552JCherokee Flyers Inc · Phoenixville, PABuilt 1968 · S/N 28-4997N6553JCrestwater Properties LLC · Florence, SCBuilt 1968 · S/N 28-4998N6554WTpc Air LLC · Colleyville, TXBuilt 1965 · S/N 28-20634N6555WDeeter George E · Chillicothe, OHBuilt 1965 · S/N 28-20636N6556JJabco Inc · Weston, IDBuilt 1968 · S/N 28-5002N6556WMontagnino James A · Saratoga Springs, NYBuilt 1965 · S/N 28-20637N6557JAsd LLC · Lebanon, NJBuilt 1968 · S/N 28-5003N6557WFrederick Darin L · Star, IDBuilt 1965 · S/N 28-20638N6558JKarr Dennis R · Clyde, OHBuilt 1968 · S/N 28-5004N6558WShirley Hills Aviation LLC · Macon, GAS/N 28-20639N6559WHarrison Michael W DBA · Lewisville, IDBuilt 1965 · S/N 28-20640N6560WBeaunaux John-Daniel S · Graham, WABuilt 1964 · S/N 28-20641N6561JKyode Inc · Creswell, ORS/N 28-5012N6561WAnderson Vance K · Eugene, ORBuilt 1965 · S/N 28-20642N6562JSmrekar Andrew E · Edgerton, WIBuilt 1968 · S/N 28-5013N6562WRm & Lp Ltd · Azalea, ORS/N 28-20643N6564JL K H LLC · Boyden, IABuilt 1968 · S/N 28-5016N6568JMorring Roy S · New Hope, ALBuilt 1968 · S/N 28-5021N6569JLegend Aviation LLC · Columbus, MSBuilt 1968 · S/N 28-5022N6569WAdams Ronald B · Statesboro, GABuilt 1965 · S/N 28-20650N6570JJenkins Robert Martin · Westminster, MDBuilt 1968 · S/N 28-5023N6570WMurillo Raymond · Pico Rivera, CAS/N 28-20651N6571JLima Alpha LLC · Pearcy, ARBuilt 1968 · S/N 28-5024N6572JFletchall Jeremy S · Queen Creek, AZBuilt 1968 · S/N 28-5025N6572WBoydstun Saylor Krystene · Brady, TXBuilt 1964 · S/N 28-20653N6573JBeecher Bees Inc · Beecher, ILBuilt 1968 · S/N 28-5026N6573WKing Isaac · Coahoma, TXBuilt 1965 · S/N 28-20654N6575WStrouse Joshua L · Columbia, MOBuilt 1965 · S/N 28-20656N6576JPa28 Nevada LLC · Incline Village, NVBuilt 1968 · S/N 28-5030N6577JSpark Solar Power LLC · Chandler, AZBuilt 1968 · S/N 28-5032N6577WAdventist World Aviation · Wilson, NCFirst renewal noticeBuilt 1965 · S/N 28-21273N6578JMalone W Paul · Coulee City, WAS/N 28-5033N6578WHanauer Keith A · Bloomfield, INBuilt 1965 · S/N 28-20659N65794Baker Curtiss L · Kinston, NCBuilt 1967 · S/N 28-23302N6579JBender Auto Body Inc · Middleville, MIBuilt 1968 · S/N 28-5034N657CAOlson David A · New Underwood, SDBuilt 1966 · S/N 28-22371N6580JPoppy Wayne J · New London, WIBuilt 1968 · S/N 28-5036N6580WPanero Philip J · Merritt Island, FLBuilt 1965 · S/N 28-20661N6583JPrestige Aircraft Inc · Swanton, VTBuilt 1968 · S/N 28-5040N6584WCook Margaret · Newark, CABuilt 1965 · S/N 28-20665N6588JDickerson Del A · Seffner, FLBuilt 1968 · S/N 28-5046N6588WLedbetter Danny · Muscle Shoals, ALBuilt 1965 · S/N 28-20674N6589JMertz Travis Lee · Danville, KYBuilt 1968 · S/N 28-5048N658FLRowlett William R Jr · Russellville, ARBuilt 1971 · S/N 28-7125575N6590JRegistration Pending · Rathdrum, IDRegistration pendingBuilt 1968 · S/N 28-5049N6592JWorland Flying Club LLC · Worland, WYBuilt 1968 · S/N 28-5052
Back to AD 96-10-01 R1