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.

N7668WGhahramanians Serjik · Sunland, CABuilt 1964 · S/N 28-1647N7670WSergeant Chess M · Dothan, ALBuilt 1964 · S/N 28-1651N7672WCrossroads Aviation LLC · Leesville, LABuilt 1964 · S/N 28-1653N7673WNew Horizons Aviation Inc · Goshen, INBuilt 1964 · S/N 28-1656N7674FCarter Rhonda L · Columbiana, ALBuilt 1976 · S/N 28-7725101N7675WAltitude Aircraft Leasing LLC · Burnet, TXBuilt 1964 · S/N 28-1642N7676WEsparza Vincent A · Friona, TXS/N 28-1662N7677WNikolic Peter Jr · Momence, ILBuilt 1964 · S/N 28-1663N7678WDsr-Cherokee 180 LLC · Dallas, TXBuilt 1964 · S/N 28-1665N7680WMearbell Kevin J · Niagara Falls, NYBuilt 1964 · S/N 28-1667N7682WMcintosh Doyle · North Ogden, UTBuilt 1964 · S/N 28-1670N7683FFisch David S · Leland, NCBuilt 1976 · S/N 28-7725103N7686WEcho Aviator LLC · Whitehouse, OHBuilt 1964 · S/N 28-1677N7688CCable Bradley D · Indianapolis, INBuilt 1975 · S/N 28-7625080N7688WBurns Joyce A · Sparta, MOBuilt 1964 · S/N 28-1679N7690WEngelhuber Robert H · Beulah, MIFirst renewal noticeBuilt 1964 · S/N 28-1682N7691WRoth Marshall Aviation LLC · Huntingdon, PABuilt 1964 · S/N 28-1683N7693WRobinson Charles W III · Henderson, NCBuilt 1964 · S/N 28-1686N7694FWolbert Dan S · Eagan, MNBuilt 1976 · S/N 28-7725104N7694WBates Billy R · Summerville, SCBuilt 1964 · S/N 28-1687N7695WCircle 3k LLC · Nazareth, PAS/N 28-1618N7696WKohrell Jessica L · Cherry Valley, CABuilt 1964 · S/N 28-1696N7697WBurmeister Robert A · Antelope, CABuilt 1964 · S/N 28-1698N7698WFlyhnz LLC · Oxford, NCS/N 28-1690N769RAMcclure Dennis N · Mcalpin, FLS/N 28-23164N76TXBrenner Kurt · Saint Ann, MOBuilt 1976 · S/N 28-7625102N7700WGleasman Steven J · Rockton, ILBuilt 1964 · S/N 28-1692N7701NN5746u LLC · Dover, DEBuilt 1968 · S/N 28-5147N7702NN7702n LLC · Glenford, OHBuilt 1968 · S/N 28-5149N7702WMud Duck LLC · Dover, DEBuilt 1964 · S/N 28-1695N7704WKelly John T III · Denison, TXBuilt 1964 · S/N 28-1700N7705NNagy Peter · Sebring, FLBuilt 1968 · S/N 28-5152N7706NSealey John W · Athens, TXBuilt 1968 · S/N 28-5153N7707NAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1968 · S/N 28-5154N7707WCockrell Amos L · Florence, ALBuilt 1964 · S/N 28-1705N7708WCarter Veronica D · Mesa, AZBuilt 1964 · S/N 28-1708N7709NGallette John B · Edgewood, NMBuilt 1968 · S/N 28-5157N7709WNewlin Thomas R · Montezuma, INFirst renewal noticeBuilt 1964 · S/N 28-1709N7710NSimpson Chad M · Dover, OHBuilt 1968 · S/N 28-5158N7710WRegistered aircraftBuilt 1964 · S/N 28-1711N7713NSingh Harsimran · Las Vegas, NVBuilt 1968 · S/N 28-5159N7713WBarber Mark E · Lighthouse Point, FLBuilt 1964 · S/N 28-1713N7714WCrosswinds Flight Center Inc · Drums, PABuilt 1964 · S/N 28-1718N7715NK Heart Aviation LLC · Choudrant, LABuilt 1968 · S/N 28-5162N7715WFoster Kenneth D · Saint Maries, IDBuilt 1964 · S/N 28-1720N77160Fahmy Bishoy F · Fraser, MIBuilt 1973 · S/N 28-7425111N7716NPyanov Mark · Clinton, MSS/N 28-5163N7716WWood Burton T · Richmond Hill, GABuilt 1964 · S/N 28-1721N7717NAdirondack Flying Club LLC · Rome, NYBuilt 1968 · S/N 28-5160N7717WFouse Timothy · Kittanning, PABuilt 1964 · S/N 28-1722
Back to AD 96-10-01 R1