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.

N3503KRunyon Michael · Charlotte, NCS/N 28-23591N3508KTurnquest Alexis A · West Valley City, UTS/N 28-23594N3510KMcardle Daniel C II · Hereford, AZBuilt 1967 · S/N 28-23596N3511KWilkins Sy · Jacksonville, NCBuilt 1967 · S/N 28-23598N3514KHollan Charles J · Columbia Station, OHBuilt 1967 · S/N 28-23601N3516KSteitz John III · Antioch, ILS/N 28-23602N3522KAsap Realty LLC · Stroud, OKS/N 28-23608N3526KCooke Canyon C · Marana, AZBuilt 1967 · S/N 28-23606N3529KEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 28-23544N3530KCook Richard A · Deshler, OHBuilt 1967 · S/N 28-23545N3537KKealey William J · Redondo Beach, CABuilt 1967 · S/N 28-23614N353CMIsland Air Taxi LLC · Put In Bay, OHBuilt 1976 · S/N 28-7725123N3541KGauvin Daniel G · Newport, VTBuilt 1967 · S/N 28-23616N3542KJames Anthony · Lexington, NCS/N 28-23617N3544KKelso Ted M · Fort Worth, TXBuilt 1967 · S/N 28-23618N3545KMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 28-23619N3546KPrellwitz Randy · Fairbury, NEBuilt 1967 · S/N 28-23621N3547KAlexander Robert D · Ardmore, OKBuilt 1967 · S/N 28-23622N3557KEastern Aeroworks LLC · Punxsutawney, PAS/N 28-23627N355LGLilienthal Michael · Las Vegas, NVBuilt 1969 · S/N 28-5462N3565KDb Dickinson Farms Inc · Brighton, IAFirst renewal noticeBuilt 1967 · S/N 28-23629N356CWinkler Noel A · Ann Arbor, MIBuilt 1965 · S/N 28-20995N356MTGlasscock David L · Lakewood, COBuilt 1965 · S/N 28-21274N3578KWienhold Kevin · Cuyahoga Falls, OHBuilt 1967 · S/N 28-23636N357MPEnsminger Edward C · Maryville, MOBuilt 1974 · S/N 28-7505103N357MTJ & F Aviation Adventure LLC · North Fort Myers, FLS/N 28-21389N3580KKline Justin L · Hudson, INBuilt 1967 · S/N 28-23638N3581KVick Michael S · Camden, ALBuilt 1967 · S/N 28-23639N3582KPine Point Aviation LLC · Sartell, MNBuilt 1967 · S/N 28-23641N3584KWilliamson Conner James · Hernando, FLBuilt 1967 · S/N 28-23643N3589KClark Joseph D · Kilgore, TXBuilt 1967 · S/N 28-23646N3591RAwmr LLC · Conroe, TXBuilt 1970 · S/N 28-5704N3592KBeckler Benjamin C · Middle Granville, NYBuilt 1967 · S/N 28-23647N3592RBurnt Ridge LLC · Kalispell, MTBuilt 1969 · S/N 28-5705N3596KStall Breakers LLC · Sachse, TXBuilt 1967 · S/N 28-23648N3597KQuinn Knives LLC · Julian, CABuilt 1967 · S/N 28-23649N35AMJoseph Thomas C · Raleigh, NCS/N 28-5490N35ATLoomis Matthew · Oshkosh, NEBuilt 1973 · S/N 28-7305530N3600RArapahoe Flight Club LLC · Colorado Springs, COBuilt 1969 · S/N 28-5706N3602KHoulton International Flying Club · Houlton, MEBuilt 1967 · S/N 28-23651N3604KQureini Khalil H · Strongsville, OHBuilt 1967 · S/N 28-23652N3614RKrautschun Bart · Spearfish, SDS/N 28-5710N3615RMorrissey William T Trustee · Friday Harbor, WAS/N 28-5711N3619KKirk Trevor A · Ponderay, IDBuilt 1967 · S/N 28-23656N3619RBachelor Cabin Flying Services Inc · Kokomo, INBuilt 1969 · S/N 28-5714N361WEOn Da Way Exotic Car Rentals LLC · Fort Lauderdale, FLS/N 28-23827N3620RBarker Richard · Temecula, CABuilt 1970 · S/N 28-5716N3622RN3622r LLC · Bradford, RIBuilt 1970 · S/N 28-5718N3625KAcl Airplane Holding LLC · Covington, TNBuilt 1967 · S/N 28-23658N3629RJohns Brian A · Efland, NCBuilt 1970 · S/N 28-5725
Back to AD 96-10-01 R1