OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,138

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.

N1732JWyatt Roger G · Midlothian, VAS/N 28-24145N1732TGlasgow Construction Company Inc · Guin, ALBuilt 1971 · S/N 28-7125418N1733JProkop Gregory P · Cambridge, MNS/N 28-24147N1734TTaylor David V · Clinton, NCBuilt 1970 · S/N 28-7125050N1736TN1736t LLC · Lake Point, UTBuilt 1970 · S/N 28-7125052N1737ARegistration Pending · Bulverde, TXRegistration pendingBuilt 1964 · S/N 28-1540N1737TN1737t LLC · West Palm Beach, FLBuilt 1970 · S/N 28-7125054N1738JPiper 38j LLC · Buckeye, AZBuilt 1968 · S/N 28-24153N1738TClinton 83 Aviation LLC · La Place, LAS/N 28-7125055N1739JSahli Theodore E · Costa Mesa, CABuilt 1968 · S/N 28-24154N1739TWatkins Felton III · Meridian, MSBuilt 1970 · S/N 28-7125056N1741JReynolds David Hays J · Ariton, ALS/N 28-24157N1743JRomualdi Giovanni · Torrance, CABuilt 1968 · S/N 28-24159N1745TRegistered aircraftBuilt 1970 · S/N 28-7125063N1746THessing Dale C · Eagle, IDBuilt 1970 · S/N 28-7125064N1747JCromwell James A · Little Rock, ARBuilt 1968 · S/N 28-24165N1747TErickson Carrian Brooke · Overland Park, KSBuilt 1970 · S/N 28-7125065N1748JHaywood Aviation & Salvage LLC · Atlanta, TXBuilt 1968 · S/N 28-24167N1748TBallard George M · Mchenry, ILBuilt 1970 · S/N 28-7125066N1749TCollier Tony · Grayson, KYBuilt 1970 · S/N 28-7125067N174FVy Holdings LLC · Scottsbluff, NES/N 28-854N174JRyan Aviation LLC · Forest Hills, NYBuilt 1974 · S/N 28-7405193N174PCMeyer Brian A · Milwaukie, ORBuilt 1973 · S/N 28-7425187N1750JBlackwood Aldon · Baltimore, MDBuilt 1968 · S/N 28-24169N1750TVan Strand Investments LLC · Fruita, COBuilt 1970 · S/N 28-7125068N1751JColvin Vernon H II · Warren, ARS/N 28-24170N1751TLasko C Peter · North Ft Myers, FLBuilt 1970 · S/N 28-7125069N1752HSoto Daniel · Parkland, FLS/N 28-7725158N1756JLitzenberger Troy A · Wrightwood, CABuilt 1968 · S/N 28-24175N1758TRikhy Sudeep Singh · Los Gatos, CABuilt 1970 · S/N 28-7125076N1759JBt Aero Precission Flight Accademy LLC · Stockton, CABuilt 1968 · S/N 28-24179N1759TSchiller Kenneth E · Whitmore Lake, MIBuilt 1970 · S/N 28-7125077N175ASRegistration Pending · Newberry, FLRegistration pendingBuilt 1967 · S/N 28-23778N1763JTeeter Adam B · Cambridge, MNBuilt 1968 · S/N 28-24183N1763TCroft Kevin Wallace · Durant, OKBuilt 1970 · S/N 28-7125082N1764TTrabold Peter · North Adams, MABuilt 1970 · S/N 28-7125083N1765JMay Olivia G · Santa Rosa, CABuilt 1968 · S/N 28-24185N1765TFlyhome Aviation LLC · Miami, OKBuilt 1970 · S/N 28-7125084N1767JHutcheson Jeffrey K · Council Bluffs, IABuilt 1968 · S/N 28-24188N1768JTrepanier Richard Alain · Benson, AZBuilt 1968 · S/N 28-24189N1768TButler Thomas E · Arcadia, FLBuilt 1970 · S/N 28-7125087N1769TCaudle Steve W · Glencoe, ALBuilt 1970 · S/N 28-7125088N1770TCherryhill Aviation Inc · Freetown, INBuilt 1971 · S/N 28-7125385N1772JCope Parrish B · Lemoore, CABuilt 1968 · S/N 28-24194N1776JTafaghodrad Arash · Chandler, AZBuilt 1968 · S/N 28-24198N1776TSota Charles G Jr · Kirkland, WABuilt 1970 · S/N 28-7125093N1777CHarlan Benjamin L · Madison, KSBuilt 1967 · S/N 28-23490N1777JHoward David Patrick · Thomasville, NCBuilt 1968 · S/N 28-24199N1778YWade Jason E · Salem, INBuilt 1966 · S/N 28-22261N1779JMidwest Aviators · Robinson, ILS/N 28-24202
Back to AD 96-10-01 R1