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.

N7545RWoodworth Rachel L · Louisville, KYBuilt 1966 · S/N 28-22107N7545W7545w LLC · Liberty, SCBuilt 1963 · S/N 28-1478N7547RGreene Peter Clune · Sag Harbor, NYBuilt 1966 · S/N 28-22109N7548WKaufold Richard · Ridge, NYBuilt 1963 · S/N 28-1481N7549RHerring Josh G · Boston, GAFirst renewal noticeBuilt 1966 · S/N 28-22111N7549WEarnest Matthew M · Norman, OKBuilt 1963 · S/N 28-1483N7550RMerrick David D · Rochester, INBuilt 1966 · S/N 28-22113N7550WPebsworth Randal · Shallowater, TXBuilt 1963 · S/N 28-1485N7552WHeldt Jason R · Athens, WIBuilt 1963 · S/N 28-1487N7553WGates Marshall D III · Pittsford, NYBuilt 1963 · S/N 28-1488N7554WWiener Scott J · Santa Barbara, CABuilt 1963 · S/N 28-1493N7556WSamuelson Dirk H · Orland Park, ILBuilt 1963 · S/N 28-1495N7558RDodson Collin B · Weston, WVBuilt 1966 · S/N 28-22121N7559RPetersen Josh · Wasilla, AKBuilt 1966 · S/N 28-22122N7559WOwens Alvin D · Malden, MOBuilt 1964 · S/N 28-1500N7561WRay James L Jr · Meridianville, ALBuilt 1963 · S/N 28-1502N7562RDjm Investments Inc · Menno, SDBuilt 1966 · S/N 28-22126N7563RWright Barry C · Skidmore, MOBuilt 1966 · S/N 28-22127N7565RKnox County Flying Club · Owls Head, MES/N 28-22129N7565WHurdle Scott R · Clemmons, NCBuilt 1963 · S/N 28-1506N7566RHill Bruce W · Newton, ILBuilt 1966 · S/N 28-22130N7566WStrobel Gary D · Mooresville, NCBuilt 1964 · S/N 28-1507N7567RThomas Baley B · Zavalla, TXFirst renewal noticeBuilt 1966 · S/N 28-22131N7570WWatkins Andrew B · Redding, CABuilt 1964 · S/N 28-1513N7573RMonadnock Choppers LLC · North Swanzey, NHBuilt 1966 · S/N 28-22140N7574RWilliams Brian M · Lisbon, OHBuilt 1966 · S/N 28-22141N7575WAndrejack Nick A · Montrose, PABuilt 1964 · S/N 28-1522N7576RStanfill Larry · Tujunga, CABuilt 1966 · S/N 28-22143N7576WDavenport Larry L · Fort Scott, KSBuilt 1963 · S/N 28-1448N7578RSteinhiser Scott C · New Berlin, WIBuilt 1966 · S/N 28-22145N7578WWeakley Enterprise LLC · Ashland City, TNS/N 28-1476N7579WAll For Yu Consulting Corp · Macon, GABuilt 1964 · S/N 28-1515N7581RMiller Galen E · Lewistown, ILS/N 28-22343N7581WSutherland Joel C · Greenbrier, TNBuilt 1964 · S/N 28-1523N7582WKoch Scott A · Voorhies, IABuilt 1964 · S/N 28-1524N7583RFoster William E · Red Bluff, CABuilt 1966 · S/N 28-22150N7584RMurphey Larry D · Notus, IDBuilt 1966 · S/N 28-22151N7585RArmy Air Force LLC · Los Lunas, NMBuilt 1966 · S/N 28-22152N7585WCurrie Mark H · Justin, TXBuilt 1964 · S/N 28-1533N7586RReyes Michael · Hereford, TXBuilt 1966 · S/N 28-22153N7587RFca Flight Training LLC · Washington C H, OHS/N 28-22154N7587WHawbaker Ray · Quinter, KSBuilt 1964 · S/N 28-1537N7588CGrand Aviation Inc · Grove, OKBuilt 1975 · S/N 28-7625076N7588WRustic Getaways LLC · Eagar, AZBuilt 1964 · S/N 28-1538N7591RRight Rudder Brothers LLC · East Point, GABuilt 1966 · S/N 28-22158N7591WBurin John · Durango, COBuilt 1964 · S/N 28-1541N7593RPiasecki Christopher Andrew · Lemont, ILBuilt 1966 · S/N 28-22161N7595RTedeschi Steve · Irving, TXS/N 28-22163N7595W180 Inc · Shelby Township, MIBuilt 1964 · S/N 28-1548N7596RChocolaterie Ltd · Des Moines, IAS/N 28-22164
Back to AD 96-10-01 R1