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.

N7789WNguyen Tu K · Huntington Beach, CAS/N 28-1798N7790NSchmid Daniel J · Dodgeville, WIBuilt 1968 · S/N 28-5238N7790WSpratt Don · Groveland, FLBuilt 1964 · S/N 28-1800N7791NMinmill William J · Comfort, TXBuilt 1969 · S/N 28-5239N7791WLunceford Andrew · Morgan Hill, CABuilt 1964 · S/N 28-1801N7792NRise Aircraft 2 LLC · Tomball, TXBuilt 1968 · S/N 28-5240N7792WMoffit Matthew · West Memphis, ARFirst renewal noticeBuilt 1964 · S/N 28-1802N7793WEa Aircraft Holdings LLC · Myrtle Point, ORBuilt 1964 · S/N 28-1804N7794NAnderson Ernie N · Troutman, NCBuilt 1968 · S/N 28-5243N7796WTuttle Jason D · Denver, COBuilt 1964 · S/N 28-1808N7797NSprague Joseph G · Hendersonville, NCBuilt 1968 · S/N 28-5246N7797WCameo Aviation Group LLC · Manchester, MOBuilt 1964 · S/N 28-1779N7798WLeopard James · Huntersville, NCS/N 28-1783N779LKAtmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CABuilt 1967 · S/N 28-24022N77TBGlass Ralph D · Elgin, TXS/N 28-21487N7801NGeorge Monte · Medford, ORBuilt 1968 · S/N 28-5199N7801WRegistered aircraftBuilt 1964 · S/N 28-1799N7803W3w Group Inc · Hot Springs, ARS/N 28-1807N7804NApaa Aviation Group LLC · Frisco, TXBuilt 1969 · S/N 28-5254N7805NCorrigan Air Center · Hondo, TXBuilt 1968 · S/N 28-5256N7806NTab Air Time LLC · Longmont, COBuilt 1968 · S/N 28-5257N7807NBwh Leasing LLC · Lewes, DEBuilt 1968 · S/N 28-5258N7809NUninsured Justice Enterprises LLC · Joplin, MOBuilt 1968 · S/N 28-5260N7809WHand Lawrence E · Klamath Falls, ORBuilt 1964 · S/N 28-1816N780DAFawley Dean · Newnan, GABuilt 1969 · S/N 28-5328N7812NSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28-5264N7812WSidner Jeffrey Paul · Colorado Springs, COBuilt 1964 · S/N 28-1820N7813WMnt Aviation LLC · Fairmont, WVBuilt 1964 · S/N 28-1821N7814NBynum Robert Austin II · San Antonio, TXS/N 28-5265N7815NSmall World Aero Solutions LLC · Belton, TXBuilt 1969 · S/N 28-5266N7816NMagee Michael J · Olathe, KSBuilt 1969 · S/N 28-5267N7818NFubar Flyers Inc · Port Charlotte, FLBuilt 1968 · S/N 28-5270N7819NNewton James L · Bella Vista, ARBuilt 1969 · S/N 28-5271N7819WCal Aerofab Flight Academy Inc · Chino, CABuilt 1964 · S/N 28-1828N781SWScott Robert E · Sarasota, FLBuilt 1968 · S/N 28-4958N7820NPisas Flyers Inc · East Alton, ILBuilt 1968 · S/N 28-5272N7820WJamah Hani · Boonville, CAS/N 28-1829N7821NStradtner Adam · Laporte, INBuilt 1968 · S/N 28-5273N7823NKaiten Aviation LLC · North Haven, CTBuilt 1968 · S/N 28-5275N7823WCdm Dirt LLC · Snowflake, AZBuilt 1964 · S/N 28-1840N7824NMcatarian Mark F · Saint Marys, KSBuilt 1969 · S/N 28-5277N7824WHornbill Aviation LLC · Incline Village, NVBuilt 1964 · S/N 28-1835N7825ND&D Vision Air LLC · Aubrey, TXBuilt 1968 · S/N 28-5278N7825WNelson Aaron D · Carver, MNBuilt 1964 · S/N 28-1837N7827NBest John P · Goldsboro, NCBuilt 1969 · S/N 28-5280N7827WWoods Perry H · Brownsville, TXS/N 28-1842N7828NBurris Jamey E · Mt Juliet, TNBuilt 1969 · S/N 28-5281N7828WIliff Aircraft Repair And Service Co Inc · Tulsa, OKBuilt 1966 · S/N 28-3759N7829NRoth Colin E · Anchorage, AKBuilt 1969 · S/N 28-5282N7829WBormann Charles F · Mooresville, NCBuilt 1964 · S/N 28-1844
Back to AD 96-10-01 R1