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.

N5856WSergeant Mary E · Harvard, ILBuilt 1965 · S/N 28-2361N5858WPaulisin George W · Crossville, TNBuilt 1965 · S/N 28-2368N585DEHouston Fire Aviators LLC · Houston, TXBuilt 1968 · S/N 28-4660N586Poppino James D · Titusville, FLBuilt 1967 · S/N 28-23892N5861ULasc Aviation Inc · Callaway, FLBuilt 1970 · S/N 28-26692N5863UReithaar Max R · Clinton, WABuilt 1970 · S/N 28-26695N5864UBoehm William Dean · Baldwin, ILBuilt 1970 · S/N 28-26696N5864WAmerican Heritage Aviation LLC · Jacksonville, FLBuilt 1965 · S/N 28-2387N5865URuehl Charles R · Gulf Shores, ALBuilt 1970 · S/N 28-26697N5865WA L Aviation LLC · Boiling Springs, SCBuilt 1965 · S/N 28-2398N5866UNicholson Troy B · Franklinton, LABuilt 1969 · S/N 28-26698N5866WCapitol City Aviation Inc · West Sacramento, CABuilt 1965 · S/N 28-2427N5868WAshton Paul D · Shelby Township, MIBuilt 1965 · S/N 28-2444N586FLAce Aircraft Leasing Inc · Nazareth, PABuilt 1971 · S/N 28-7125444N5870UWhite Thomas A · Roanoke, TXBuilt 1970 · S/N 28-26702N5873WPropst David A · Exchange, WVS/N 28-2503N5874UFlying Wright Aviation LLC · Henderson, NVS/N 28-26707N5875UTews Jamie S · Greenville, WIBuilt 1970 · S/N 28-26708N5876U3shahs Aviation LLC · Temecula, CAS/N 28-26709N5876WKiss George C · Bangor, PAS/N 28-2552N5878UAlbright Jasper N · Raleigh, NCBuilt 1970 · S/N 28-26710N5878WWorrell Wayne · Campbellsville, KYBuilt 1965 · S/N 28-2555N5879UJacobs Levon Jr · Oak Hill, FLBuilt 1970 · S/N 28-26713N5880WDurkin Michael T · Sunland, CABuilt 1965 · S/N 28-2570N5881URegistered aircraftBuilt 1970 · S/N 28-26715N5882UMartinez Guillermo E · Upland, CABuilt 1970 · S/N 28-26716N5884UB & R Aircraft LLC · Wadsworth, OHS/N 28-26719N5887UFretz Richard G · Harrisburg, PABuilt 1970 · S/N 28-26722N5888ULynch Francis X · Dumont, NJBuilt 1970 · S/N 28-26755N5889WHarrison Joshua · Canyon Country, CABuilt 1965 · S/N 28-2627N5890UKempton Lana Julia Trustee · Douglasville, GABuilt 1970 · S/N 28-26786N5891U2dwh LLC · Katy, TXBuilt 1970 · S/N 28-26727N5891WMarino Mario Mennona · King Of Prussia, PABuilt 1965 · S/N 28-2633N5892UFeighl Engineering Group Inc · Hot Springs, ARS/N 28-26735N5893UCasper Gary · Spring Creek, NVBuilt 1970 · S/N 28-26706N5893WFinch Howell M Jr · Victoria, TXBuilt 1965 · S/N 28-2645N5896UGift Academy Inc · Vernon, TXS/N 28-26792N5898WFrazier Justyn K · Mesa, AZS/N 28-2708N58AEKraujales Adam M · East Moriches, NYS/N 28-5075N58YMTailwind Partners LLC · Valparaiso, INBuilt 1967 · S/N 28-4515N5902WWald Charles E · Greenwood, MOBuilt 1965 · S/N 28-2752N5903WCluff Benjamin · Meridian, IDBuilt 1965 · S/N 28-2967N5904UGilded Gull Aviation LLC · Middletown, RIBuilt 1970 · S/N 28-26891N5904WReinhart Adam R · Courtland, MNBuilt 1965 · S/N 28-2699N5906WGjj LLC · Kalispell, MTBuilt 1965 · S/N 28-2814N5908UEcostudio Real Estate LLC · South Amboy, NJBuilt 1970 · S/N 28-26505N5908WPrindle Ry · Hillsboro, ORBuilt 1965 · S/N 28-2879N5909WCornebise Ricky · Levelland, TXBuilt 1966 · S/N 28-3032N590FLDonnelly Matthew J · Romulus, NYS/N 28-7125452N590RUSA Jet And Helicopter Inc · Denver, NCBuilt 1965 · S/N 28-21327
Back to AD 96-10-01 R1