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.

N38580Avier LLC · Beverly, MABuilt 1977 · S/N 28-7725286N3860RLundgren Christopher B · Graham, TXBuilt 1970 · S/N 28-5833N3862KNeihart Randy L · Fontana, CABuilt 1967 · S/N 28-23753N3866RDurgin William W · Waquoit, MABuilt 1970 · S/N 28-5845N3868RGentry Donald R · Welaka, FLBuilt 1969 · S/N 28-5770N38692Markis Dean · Lake Worth, FLBuilt 1977 · S/N 28-7725263N3871RFly Vermont LLC · Swanton, VTBuilt 1970 · S/N 28-5846N3879RFox Pond Farm · Indian Trail, NCFirst renewal noticeBuilt 1970 · S/N 28-5851N38809Somerset Air Service Inc · Bedminster, NJBuilt 1977 · S/N 28-7725250N3882RPeterson Dennis W · Grenora, NDS/N 28-5855N3892KRowley Rodney N · Duchesne, UTS/N 28-23763N38GHLagemann Jeffrey P · Cocoa, FLS/N 28-4264N38LSLambert Larry W · Plain City, OHBuilt 1963 · S/N 28-1348N38NBSailer Christopher J · Loveland, OHBuilt 1965 · S/N 28-2764N38WMMariani Matthew J · Santa Rosa, CAFirst renewal noticeBuilt 1965 · S/N 28-2226N3905FAsadoorian Todd · Arlington, TNBuilt 1976 · S/N 28-7625269N3909KRada Norman · Hagerstown, MDBuilt 1967 · S/N 28-23776N3912XN3912x Holdings LLC · Sarasota, FLBuilt 1975 · S/N 28-7525337N3914KErmis Aviation LLC · Coleman, WIBuilt 1967 · S/N 28-23782N3915KPayne Garin Jay · Huntington Beach, CABuilt 1967 · S/N 28-23783N3915RMaloney Kylee · Kingman, KSBuilt 1970 · S/N 28-5859N3916KBell Clarence R · Pasadena, TXBuilt 1967 · S/N 28-23784N3917KBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 28-23786N3919KTerrell Thomas III · Edwards, ILBuilt 1967 · S/N 28-23788N391LTPowell Patrick C · Kenai, AKBuilt 1967 · S/N 28-24018N3920KPeriklos Andreas · Aliso Viejo, CAS/N 28-23789N3921KLewis Mark A · Ozark, ALBuilt 1967 · S/N 28-23791N3923REagle Aeronautics LLC · Chicago, ILBuilt 1970 · S/N 28-5831N3925KDte Aviation LLC · Cherry Hill, NJS/N 28-23797N3926KWatson Michael · Reedsville, PABuilt 1967 · S/N 28-23798N3926RBrowning Philip L · Beatrice, NEBuilt 1970 · S/N 28-5849N3927KNice James · Marysville, WABuilt 1967 · S/N 28-23799N3928KHanneman Resa L · Denver City, TXBuilt 1967 · S/N 28-23801N3930KQuick Jeremy R · Bremen, INBuilt 1967 · S/N 28-23803N3930RGillett Darrin L · Cedar Falls, IAS/N 28-5848N3931KAlpha 1 Aviation LLC · Helena, ALS/N 28-23804N3935KKrog Steven L · Hartford, WIBuilt 1967 · S/N 28-23809N3938KCdb Group Holdings LLC · Sheridan, WYBuilt 1967 · S/N 28-23813N3939KRegistration Pending · Grand Prairie, TXRegistration pendingBuilt 1967 · S/N 28-23814N3939RReid Edwin G Jr · Hollywood, MDBuilt 1970 · S/N 28-5850N3940KAir Ventures Flying School LLC · Smithfield, RIBuilt 1967 · S/N 28-23764N3941KHawkins Allan S · Lizella, GABuilt 1967 · S/N 28-23816N3944KPeiker Laramie · Revillo, SDBuilt 1967 · S/N 28-23819N3945KFisher Knute A · Kensington, CABuilt 1967 · S/N 28-23821N3945RJpx Aero Club Corp · East Hampton, NYBuilt 1970 · S/N 28-5854N3948KMcilroy William E · Dyer, INBuilt 1967 · S/N 28-23824N3952KKnight Brett · Franklin, IDS/N 28-23829N3952RLovell Mark S · Templeton, CABuilt 1970 · S/N 28-5847N3953KRamsden Bruce A · Stillwater, MNBuilt 1967 · S/N 28-23831N3954RGlover Thomas B Jr · Marana, AZS/N 28-7105059
Back to AD 96-10-01 R1