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.

N8158NHorizon Aviation LLC · Brooks, GABuilt 1968 · S/N 28-25353N8158WMills Jeroldine C · Altaville, CAS/N 28-2274N8159WDowner Jesse S · Acampo, CABuilt 1965 · S/N 28-2275N8161NKale Timothy E · Kailua Kona, HIBuilt 1968 · S/N 28-25357N8161WPs Air Group LLC · Cape May, NJBuilt 1965 · S/N 28-2278N8162WBistline Fredrick G · Page, AZBuilt 1965 · S/N 28-2279N8163WAkins Daryl D · Creighton, MOBuilt 1965 · S/N 28-2280N8164WAerovia LLC · Austin, TXS/N 28-2281N8167NAlley Bryan T · Pensacola, FLBuilt 1969 · S/N 28-25363N8167WDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2285N8169NMiller Marcus Wayne · Oklahoma City, OKBuilt 1968 · S/N 28-25365N816WAFredericks Ruth · Miami, FLS/N 28-7525173N8170NFalter George H III · Baltimore, MDBuilt 1968 · S/N 28-25366N8171NOndrovic Rick · Belton, SCBuilt 1968 · S/N 28-25367N8171WAnderson Christopher J · Ogden, UTBuilt 1965 · S/N 28-2291N8172WMile High Advertising LLC · Dover, DEBuilt 1965 · S/N 28-2294N8173NJones Roy F · Benson, AZBuilt 1968 · S/N 28-25369N8173WRoadrunner Flight School LLC · Farmington, NMS/N 28-2295N8174WJeffers Coreen · Bellmawr, NJBuilt 1965 · S/N 28-2298N8176NPlane Doc LLC · Phoenix, AZS/N 28-25372N8177NAspiras Dionisio O Jr · Rosharon, TXBuilt 1968 · S/N 28-25373N8177WDavis James Warren · Albemarle, NCBuilt 1965 · S/N 28-2301N8179NFletcher William J · Mason, NHBuilt 1968 · S/N 28-25375N8179WLynch Gary L · Ocala, FLBuilt 1965 · S/N 28-2303N8180WD And D Air Inc · Paola, KSBuilt 1965 · S/N 28-2305N8181NBald Eagle Flying Club · South Portland, MEBuilt 1968 · S/N 28-25377N8182NJlf Air Inc · Evansville, INBuilt 1969 · S/N 28-25378N8182WSwillen Richard Carl · Easley, SCBuilt 1965 · S/N 28-2307N8183NTucker Richard D · Locust, NCBuilt 1968 · S/N 28-25379N8183WN8183w LLC · Hershey, PABuilt 1965 · S/N 28-2309N8184WBaker John L · Killen, ALBuilt 1965 · S/N 28-2310N8185NWright Edward J Jr · San Antonio, TXBuilt 1969 · S/N 28-25382N8186NMorris Thomas L · Fairmont, WVBuilt 1969 · S/N 28-25383N8186WStough Stephen A · Reno, NVBuilt 1965 · S/N 28-2313N8187WViroqua Area Flyers Inc · Viroqua, WIS/N 28-2314N8188WBrewer Jordan L · Waynesboro, TNBuilt 1965 · S/N 28-2315N8189WTri-City Mens Health LLC · Prescott, AZBuilt 1965 · S/N 28-2316N818DVQuiroz Rene Joseph · Matthews, NCBuilt 1969 · S/N 28-26447N818HEMaxwell James P · Rolling Prairie, INBuilt 1970 · S/N 28-5832N8190WA&M Aviation LLC · Tewksbury, MABuilt 1965 · S/N 28-2317N8192NNaber Adam T · Fort Atkinson, WIBuilt 1969 · S/N 28-25390N8192WHenley Edward F · Headland, ALBuilt 1965 · S/N 28-2319N8193WButler Austen James · Charlotte, NCBuilt 1965 · S/N 28-2320N8195WN7396w LLC · Coeymans Hollow, NYBuilt 1965 · S/N 28-2323N8196NJensen Aviation LLC · Zephyrhills, FLBuilt 1969 · S/N 28-25394N8196WRensberger Scott C · Lake Jackson, TXBuilt 1965 · S/N 28-2324N8198NSpooner John R Jr · Atascadero, CABuilt 1969 · S/N 28-25397N8198WGreenshields Brett William · Eastvale, CABuilt 1965 · S/N 28-2326N81DGRae Seth R · Spotsylvania, VABuilt 1967 · S/N 28-4579N81MHSvedrovic Alex P · Waterbury, CTBuilt 1968 · S/N 28-24238
Back to AD 96-10-01 R1