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.

N7871WWisdom Gary A · Farmersville, TXBuilt 1964 · S/N 28-1893N7872WHeard Derrick A · Greensboro, NCBuilt 1964 · S/N 28-1894N7874WLink John P · West Milford, NJBuilt 1964 · S/N 28-1898N7877WShields John R · Chester, NHBuilt 1964 · S/N 28-1901N7879WFlyhome One LLC · Chandler, AZBuilt 1964 · S/N 28-1903N787BRNaron Robert W · Poolville, TXBuilt 1965 · S/N 28-2091N7880WSefinas Avir LLC · Brooklyn, NYBuilt 1964 · S/N 28-1904N7881WEast Crest Management LLC · Eastvale, CABuilt 1964 · S/N 28-1905N7882CKeck Joseph S · Las Vegas, NVS/N 28-7625087N7882WDickerson Gregory L · St Maries, IDS/N 28-1906N7883WStack Brian James · Paso Robles, CABuilt 1964 · S/N 28-1907N7885WCp Authority LLC · Poulsbo, WABuilt 1964 · S/N 28-1909N7886WChelena Eric D · San Antonio, TXBuilt 1964 · S/N 28-1910N7887WDepp Gregory B · Ft Worth, TXBuilt 1964 · S/N 28-1911N7888WLashinski Michael J · Monument, COBuilt 1964 · S/N 28-1912N7889WBetts Paula H · Valparaiso, INBuilt 1964 · S/N 28-1913N788RKSalomonsson Mats E · Hayward, CAS/N 28-24831N7891WN7891w LLC · North Las Vegas, NVBuilt 1964 · S/N 28-1916N7892WRegistered aircraftBuilt 1964 · S/N 28-1917N7894WWiley Thomas W · Anchorage, AKBuilt 1964 · S/N 28-1921N7897WDimario Carmen · Wilmington, DEBuilt 1964 · S/N 28-1925N7899WAmmon Sol · Papaaloa, HIS/N 28-1928N789DWFergus Falls Aviation LLC · Fergus Falls, MNBuilt 1973 · S/N 28-7325258N789PZarski Rebecca Cross · Sharon Springs, NYBuilt 1972 · S/N 28-7205303N789PALong Jacob · Jupiter, FLBuilt 1975 · S/N 28-7525240N78MJTalley Patricia · Asheboro, NCBuilt 1973 · S/N 28-7325319N7900WDiedrich Paul E · Fort Mill, SCBuilt 1964 · S/N 28-1929N7902WHicks Mark T · Newark, CABuilt 1964 · S/N 28-1931N7904WRobins Steven W · Franklinton, LAS/N 28-1934N7907WRegistration Pending · El Prado, NMRegistration pending, canceledBuilt 1964 · S/N 28-1937N7908WEmerald Coast Flying Club LLC · Fort Walton Beach, FLBuilt 1964 · S/N 28-1939N7909WCircus Of Six LLC · Wilmington, DEBuilt 1964 · S/N 28-1942N790YAB & T Aviators Inc · Wantagh, NYBuilt 1967 · S/N 28-23668N7911NRynearson Mark J · Wolcott, NYBuilt 1969 · S/N 28-5323N7911WSandidge Richard A · Pueblo, COBuilt 1964 · S/N 28-1944N7913NStamps David R · Sparta, TNBuilt 1969 · S/N 28-5325N7913WStream Aviation LLC · Luther, OKBuilt 1964 · S/N 28-1946N7914NTeeters Gregory R · Bossier City, LABuilt 1969 · S/N 28-5326N7914WInstrument Trainer Flying Club Inc · Champaign, ILBuilt 1964 · S/N 28-1947N7917WRoss Eric L · Peoria, AZS/N 28-1953N7919NLa Grassa William W · Sacramento, CABuilt 1969 · S/N 28-5330N7919WFarabee Mechanical Inc · Hickman, NEBuilt 1964 · S/N 28-1956N791DAFox Norman A · Maryville, TNBuilt 1969 · S/N 28-25848N791LNieves Oscar A · Carolina, PRBuilt 1969 · S/N 28-26078N7920NN7920n LLC · Sioux Falls, SDBuilt 1969 · S/N 28-5331N7920WJb III LLC · Stuart, FLBuilt 1964 · S/N 28-1957N7921NBolin Paul C · Vancouver, WABuilt 1969 · S/N 28-5332N7922NMemo Air Services LLC · San Antonio, TXBuilt 1969 · S/N 28-5333N7922WVouk Frank E · Firth, IDBuilt 1964 · S/N 28-1960N7923NGcc Aviation LLC · Elberton, GABuilt 1969 · S/N 28-5334
Back to AD 96-10-01 R1