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.

N7718NKlinedinst D Eric · Carlisle, PABuilt 1968 · S/N 28-5027N7718WClyde Fliers Inc · Fremont, OHBuilt 1964 · S/N 28-1724N7719WKnudson Douglas E · Morris, ILBuilt 1964 · S/N 28-1725N771WSCampbell Reginald G · Hilo, HIS/N 28-24767N7720WLagrange LLC · East Helena, MTBuilt 1964 · S/N 28-1726N7721NRome Nicholas S · Olathe, KSBuilt 1969 · S/N 28-5167N7721WKosobud Timothy J · Adams, WIBuilt 1964 · S/N 28-1727N7722WKratzer Ernest W · Castaic, CABuilt 1964 · S/N 28-1729N7723NFord Charles D · Clifton, TNFirst renewal noticeBuilt 1968 · S/N 28-5166N7725NHangar Twenty Two Aviation LLC · Athens, TXBuilt 1968 · S/N 28-5169N7726WJrw Flight LLC · Huntsville, MOBuilt 1964 · S/N 28-1733N7727WAukee Isaac J · Ironwood, MIBuilt 1964 · S/N 28-1734N7728NP-Factor Aviation LLC · Hoover, ALBuilt 1969 · S/N 28-5172N7728WSchrage Kevin J · Trevor, WIBuilt 1964 · S/N 28-1735N7729CPeterman Keith · Taylorsville, KYBuilt 1975 · S/N 28-7625082N7730WSuh Y H Charles · Rowland Heights, CABuilt 1964 · S/N 28-1738N7731NThompson Randy L · Anderson, CAS/N 28-5174N7732WWoodhead James R · Charleston, SCBuilt 1964 · S/N 28-1740N7733NS Dacy Enterprises Inc · Harvard, ILBuilt 1968 · S/N 28-5176N7733WSwyers Stinson R · Ottsville, PABuilt 1964 · S/N 28-1741N7734NStewart Duncan · Long Beach, CABuilt 1968 · S/N 28-5177N7734WBrown Tyler M · Cary, NCBuilt 1964 · S/N 28-1742N7735NMelanson Wayne L · Liberal, KSBuilt 1968 · S/N 28-5180N7737NKoch Michael R · Nemo, SDBuilt 1968 · S/N 28-5181N7737WGt Air LLC · Burton, OHBuilt 1964 · S/N 28-1745N7738NBluegrass Aviation LLC · Springdale, ARBuilt 1968 · S/N 28-5182N7738WFlying Turtle Management LLC · Ellicott City, MDBuilt 1965 · S/N 28-2915N7739NSenia John A · Berlin, CTBuilt 1968 · S/N 28-5183N7740NLenderman Steven E · Sharpsburg, GABuilt 1968 · S/N 28-5184N7740WReiger Roger L · Lafayette, INBuilt 1964 · S/N 28-1748N7741NBrindle Richard L · Pleasant Hall, PABuilt 1969 · S/N 28-5186N7742NDistler Robert · Northborough, MAS/N 28-5188N7742WDupont Micheal Rene · East Taunton, MABuilt 1964 · S/N 28-1751N7743NRegistered aircraftBuilt 1968 · S/N 28-5144N7743WAtigun Aviation LLC · Sheridan, WYBuilt 1964 · S/N 28-1752N7744TDickert Investments Holdings LLC · Cave Creek, AZBuilt 1968 · S/N 28-24073N7744WShotwell Michael · Dallas, GABuilt 1964 · S/N 28-1754N7745NAppealing Adventures Inc · Canadensis, PABuilt 1968 · S/N 28-5189N7745WSchaff Investments LLC · Stone Mountain, GABuilt 1964 · S/N 28-1755N7746FWilliams Dwight J · Wichita, KSBuilt 1976 · S/N 28-7725105N7747NShumock Jerry Ray · Moss Point, MSBuilt 1968 · S/N 28-5191N7747WFlying Family LLC · Orlando, FLBuilt 1964 · S/N 28-1757N7749FLohr Martin J · Petersburg, AKBuilt 1976 · S/N 28-7725106N7749NTeijeiro Edgar E Trustee · El Paso, TXBuilt 1968 · S/N 28-5194N774PCHarrell Brian · Auburn, ALBuilt 1973 · S/N 28-7405018N7751WSmith Derek D · Portland, ORS/N 28-1719N7752NCote Daniel A · Montpelier, VTS/N 28-5197N7752WCavender John S · Centerville, MDBuilt 1964 · S/N 28-1728N7753NSonner Michael J · Golden, COBuilt 1968 · S/N 28-5198N7753WNortheastern Oregon Flying Club Inc · La Grande, ORBuilt 1964 · S/N 28-1758
Back to AD 96-10-01 R1