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.

N6447WSeverson Eric · Waukesha, WIBuilt 1964 · S/N 28-20519N6448JMurphy Richard F · Hughesville, MDS/N 28-4867N6448RShaw Timothy E · Ashtabula, OHBuilt 1966 · S/N 28-21631N6448WSierra Lima Aviation LLC · Riverton, UTS/N 28-20520N644FLAty Aviation Inc · Watertown, SDBuilt 1971 · S/N 28-7125552N644GRishel Keith D · Prineville, ORBuilt 1970 · S/N 28-26741N6450JBurk Kevin M · Sunset, TXBuilt 1968 · S/N 28-4869N6450RPlan Bee LLC · Washington, DCBuilt 1966 · S/N 28-21635N6450WJones Bobby R · Colorado Springs, COBuilt 1964 · S/N 28-20522N6451RDamian Richard E · Sioux Falls, SDBuilt 1966 · S/N 28-21636N6451WHickman John N · Mohave Valley, AZBuilt 1964 · S/N 28-20523N6452ROr-El Elbaz · Woodland Hills, CABuilt 1966 · S/N 28-21637N6453JN6529r LLC · Manassas, VABuilt 1968 · S/N 28-4874N6453RHerman Aaron T · Bryan, OHS/N 28-21638N6453WN6453w LLC · Orlando, FLS/N 28-20526N6454WSm Aviation LLC · Clermont, FLBuilt 1964 · S/N 28-20527N6455JCartier Edward J Jr · Columbia, MSBuilt 1968 · S/N 28-4876N6456JCherokee Dream Inc · Wilmington, DEBuilt 1968 · S/N 28-4877N6456RCash Douglas Edward · San Antonio, TXBuilt 1966 · S/N 28-21642N6457JHatcher Clifford J · Dallas, GABuilt 1968 · S/N 28-4878N6457WWeston Keith M · Ogdensburg, NYBuilt 1964 · S/N 28-20530N6458JFlorida Tectonics Inc · Weirsdale, FLBuilt 1968 · S/N 28-4880N6458WJones Larry · Clovis, NMBuilt 1965 · S/N 28-20531N6459RLogical Drive Inc · Siler City, NCBuilt 1966 · S/N 28-21645N6459WBillingsley Littleton C Jr · Spicewood, TXBuilt 1964 · S/N 28-20532N645FLRule Charles Y · Mineral Point, WIBuilt 1971 · S/N 28-7125553N6461RBetsy N6461r LLC · Novato, CABuilt 1966 · S/N 28-21648N6461WOverstreet Aviation LLC · Sunray, TXBuilt 1964 · S/N 28-20534N6462JRentz Bradford C · Baxley, GABuilt 1968 · S/N 28-4885N6462RGoodens Floorcovering Inc · Tallapoosa, GABuilt 1966 · S/N 28-21650N6462WBauer Richard M · Greensboro, NCBuilt 1965 · S/N 28-21264N6463JSorenson Mark A · Senoia, GABuilt 1968 · S/N 28-4886N6464WTechnical Educational Services Inc T/A · Virginia Beach, VABuilt 1964 · S/N 28-20537N6465JAardvark Aviation Inc · Greentown, INS/N 28-4889N6466JHomesick Angel Aircraft Management · Grove, OKS/N 28-4890N6467JAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1968 · S/N 28-4892N6467RKightlinger Kenny L Jr · Murfreesboro, TNS/N 28-21655N6467WStichnoth Marvin L · Bourbonnais, ILBuilt 1964 · S/N 28-20540N6468JTxfliers Aviation LLC · Corpus Christi, TXBuilt 1968 · S/N 28-4893N6468RMargolis Brian M · Florence, MABuilt 1966 · S/N 28-21656N6469JDouble Eagle Flyers LLC · Albuquerque, NMBuilt 1968 · S/N 28-4894N6469RBaboul Anwar G · Carmel, INBuilt 1966 · S/N 28-21657N6469WPivotal Aviation LLC · Spartanburg, SCBuilt 1964 · S/N 28-20542N646FLTaylor William L · Fairfield, ILBuilt 1971 · S/N 28-7125554N6470JSitlinger Angela R · Gratz, PABuilt 1968 · S/N 28-4896N6470RAlterio Mark G · North Andover, MAS/N 28-21658N6470WO'Kelly Albert · Caruthers, CABuilt 1964 · S/N 28-20543N6471JMartinez Paul · Sonora, TXBuilt 1968 · S/N 28-4897N6471RStraw Robert D · Farmington, MNBuilt 1966 · S/N 28-21659N6472JFAA Flying Club Inc · Springfield, VABuilt 1968 · S/N 28-4898
Back to AD 96-10-01 R1