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.

N5586USoisson Douglas M · Barnesville, GABuilt 1969 · S/N 28-26316N55870Legacy Aviation LLC · Tea, SDS/N 28-7305487N55879Buchholtz Tony E · Greenville, OHBuilt 1973 · S/N 28-7325485N55880Wings Up LLC · Saint Augustine, FLBuilt 1973 · S/N 28-7325517N55881Phoenix Kingdom LLC · Washington, DCS/N 28-7325518N55884Mcgee Daniel J · Indianola, IABuilt 1973 · S/N 28-7305491N5588FRckr Aviation LLC · Chehalis, WABuilt 1968 · S/N 28-24921N5588UMontgomery Richard E · Omaha, NEBuilt 1969 · S/N 28-26318N5588WBartz Nicole · Cleveland, MOBuilt 1962 · S/N 28-725N55890S & L Sports LLC · New Hampton, IABuilt 1973 · S/N 28-7305492N55899Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28-7325521N5589FTjl Aviation LLC · Atlanta, GABuilt 1968 · S/N 28-24922N5589UGq Aviation LLC · Cherry Hill, NJBuilt 1969 · S/N 28-26320N558FLRoyal Greene Holdings LLC · Spout Spring, VABuilt 1971 · S/N 28-7125399N558SMTsvang Volodymyr · Redondo Beach, CABuilt 1975 · S/N 28-7505130N55905Top Coat Takeoff LLC · Cincinnati, OHBuilt 1973 · S/N 28-7305496N5590FLee A Archer Jr Red Tail Youth Flying Progrom Inc · New Windsor, NYS/N 28-24923N55913Buckner Business Services Inc · Trenton, MOBuilt 1973 · S/N 28-7305497N55915Loncella James G · Johnstown, PABuilt 1973 · S/N 28-7305500N5591WMontag Mark W · Pine River, WIBuilt 1962 · S/N 28-794N55920Gillbreath Monty Everett · Livingston, TXS/N 28-7325529N55925Goodwin Collin H · Hobbs, NMS/N 28-7325532N5592FEagle Air Flying Club Inc · Bowling Green, OHBuilt 1968 · S/N 28-24879N55930Lafrance Troy R · Paola, KSBuilt 1973 · S/N 28-7325534N55932Red Eagle Aviation LLC · Deridder, LABuilt 1973 · S/N 28-7305503N55933Knoxville Aviation · Knoxville, IAS/N 28-7305504N55934Roloff Paul E Trustee · Waupaca, WIBuilt 1973 · S/N 28-7305505N55938Turner Cole M · Round Rock, TXBuilt 1973 · S/N 287325536N55940Zadrick Wayne J · Bristol, CTBuilt 1973 · S/N 28-7325537N55942Ray Lynn M · Cloquet, MNBuilt 1973 · S/N 28-7325538N55954Registration Pending · Jacksonville, FLRegistration pendingBuilt 1973 · S/N 28-7325539N55955Pierce Riley Deirdre · Chicago, ILBuilt 1973 · S/N 28-7325542N5595FByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28-24883N55965Greene County Flying Club · Waynesburg, PABuilt 1973 · S/N 28-7305510N55967Hisman Gary L · Skagway, AKS/N 28-7305511N5596UPine Aviation Inc · Sheridan, WYBuilt 1969 · S/N 28-26326N55973Crase Nicole Trustee · Mansfield, OHBuilt 1973 · S/N 28-7325543N55975Pena Leonardo · The Colony, TXBuilt 1973 · S/N 28-7325545N55977Walker Benjamin M · Weatherford, TXBuilt 1973 · S/N 28-7305512N5597FDeardorff Karl R · San Luis Obispo, CABuilt 1968 · S/N 28-24853N5597UFejor Inc · San Juan, PRBuilt 1969 · S/N 28-26327N5597WLathrop Christopher A · Palmyra, WIBuilt 1962 · S/N 28-733N55988Murawski Rene · Clarkston, MIBuilt 1973 · S/N 28-7325549N5598FKeran Gary R · New Holstein, WIBuilt 1976 · S/N 28-7725064N5598UHilton Colby W · Amarillo, TXBuilt 1969 · S/N 28-26328N5598WBall Dontel J · Tacoma, WAS/N 28-734N5599WPhoenix Aviation LLC · Claremore, OKBuilt 1962 · S/N 28-736N559ESeitan Eduard · Chicago, ILS/N 28-3248N559FLSandlak David J · Zephyrhills, FLBuilt 1971 · S/N 28-7125400N55TBKennedy Michael Allen · Oxnard, CABuilt 1966 · S/N 28-21634
Back to AD 96-10-01 R1