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.

N1687JMarsh Flyers LLC · Britton, SDBuilt 1968 · S/N 28-24089N1688JTalley Charles B · Ignacio, COS/N 28-24091N1688TCape May Aero LLC · Cape May, NJBuilt 1970 · S/N 28-7125005N1689JHouff Christopher J · Mount Crawford, VABuilt 1968 · S/N 28-24092N1689TFun Flyers LLC · Rapid City, SDBuilt 1970 · S/N 28-7125006N168DPJohnson Eldridge Jr · Chicago, ILBuilt 1967 · S/N 28-4402N168KWWalsh Home Improvement Co Inc · Berlin, MDBuilt 1972 · S/N 28-7305031N1690THutchison Harry L · Grandview, MOS/N 28-7125007N1691JBaldwin Rickey Albert · Clarksville, VAS/N 28-24094N1692JMalkowski Joseph S Trustee · Lake Saint Louis, MOBuilt 1967 · S/N 28-24096N1692TDhawan Gautam · Madison, MSBuilt 1970 · S/N 28-7125009N1693TMoburg Kenneth · Basehor, KSS/N 28-7125010N1694JLeemans Scott J · Queen Creek, AZBuilt 1967 · S/N 28-24099N1695HVista Air Inc · Pacoima, CABuilt 1977 · S/N 28-7725155N1695JHudson John P III · Grapeland, TXS/N 28-24101N1696JHardin John M · Terrell, TXS/N 28-24102N1696TAircraft 1821 LLC · North Charleston, SCS/N 28-7125013N1699TBurgess Frank A Jr · Durham, NCS/N 28-7125016N169BTAtkison Keith · Centre, ALBuilt 1966 · S/N 28-3776N16ECSchnell Michael D · New Bremen, OHBuilt 1965 · S/N 28-2683N16JPTrue Grit Wy 2 DBA · Rozet, WYBuilt 1969 · S/N 28-25956N16RLKerr John A Jr · Dekalb, ILBuilt 1964 · S/N 28-1834N1700JStratus Aviation LLC · Newnan, GABuilt 1967 · S/N 28-24107N1701TRd Aire LLC · Opelika, ALBuilt 1970 · S/N 28-7125018N1703JCogan Betty C · Bristol, TNBuilt 1968 · S/N 28-24111N1703TAlicea Ismael · Iselin, NJBuilt 1970 · S/N 28-7125019N1704TLavieri Gary P · Seneca, SCBuilt 1970 · S/N 28-7125020N1705JPeel William · Gilbert, AZBuilt 1968 · S/N 28-24113N1705TLubeski Lawrence J · Lapeer, MIBuilt 1970 · S/N 28-7125021N1706JSkycastle Flying Club Inc · New Castle, INBuilt 1968 · S/N 28-24114N1706TMarshall Loraine · Independence, KYS/N 28-7125022N17079Speakman Donna M · Auburn, ALBuilt 1965 · S/N 28-2157N1708TN1708t Owners Assn · Chesapeake, VABuilt 1970 · S/N 28-7125023N1709JWingman Unlimited LLC · Carrollton, TXBuilt 1968 · S/N 28-24118N1710JOpen Skies Aviation LLC · Wellington, KSBuilt 1968 · S/N 28-24119N1710TGarretson Thomas A · New Smyrna Beach, FLBuilt 1970 · S/N 28-7125025N1712JTwelvejuliet LLC · Moberly, MOBuilt 1968 · S/N 28-24123N1712TLea Joe A · Mason City, IABuilt 1970 · S/N 28-7125026N1713JSimpson Mark E · Fairbanks, AKBuilt 1968 · S/N 28-24124N1714JFernandes Gary DBA · Clallam Bay, WABuilt 1968 · S/N 28-24126N1716JNess Brian · Wasilla, AKBuilt 1968 · S/N 28-24128N1716TStratus Business Development LLC · Nashua, NHBuilt 1970 · S/N 28-7125030N171WAKessenich Kimberly D · Montello, WIBuilt 1973 · S/N 287305592N1720TLumi Wings Corp · Goodyear, AZBuilt 1970 · S/N 28-7125033N1722JDonah Thomas J · Plattsburgh, NYBuilt 1968 · S/N 28-24134N1724JKeeven Diana F · Hawk Point, MOBuilt 1968 · S/N 28-24136N1725JNewton Mitchell W Sr · Huffman, TXBuilt 1968 · S/N 28-24137N1725TCarrell William G · Pittsburgh, PABuilt 1970 · S/N 28-7125036N1728JHogan Thomas A · Fairfield, OHS/N 28-24140N1731JRiverside Exteriors Inc · Post Falls, IDBuilt 1968 · S/N 28-24144
Back to AD 96-10-01 R1