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.

N6867JOtmane Lahouari · Orlando, FLBuilt 1976 · S/N 28-7625248N6868KFlamingo Air Inc · Cincinnati, OHBuilt 1973 · S/N 28-7325260N6869WRegistered aircraftS/N 28-21025N6871WSkylux Aviation LLC · Coppell, TXBuilt 1965 · S/N 28-21027N6872WMergen Andrew John · Colorado Springs, COBuilt 1965 · S/N 28-21028N6873WUptegrove James L · Susanville, CABuilt 1965 · S/N 28-21029N6874WEra Aviation LLC · Downers Grove, ILBuilt 1965 · S/N 28-21030N6877WFriedrich David Paul · Frankfort, INBuilt 1965 · S/N 28-21033N6880WRegistered aircraftBuilt 1965 · S/N 28-21036N6881WLewis Mark A · Ozark, ALBuilt 1965 · S/N 28-21037N6885WMiller Andy D · Marana, AZS/N 28-21041N6886WGregory Joshua L · Oxford, MSBuilt 1965 · S/N 28-21042N6888WAnderson Ty M · Grenada, MSBuilt 1965 · S/N 28-21045N6890WRegistered aircraftS/N 28-21047N6892WRussell Steven D · Waxhaw, NCBuilt 1965 · S/N 28-21049N6894WSummit Flight Academy LLC · Peculiar, MOBuilt 1965 · S/N 28-21053N6895WSale Reported · Brighton, COSale reportedBuilt 1965 · S/N 28-21054N6896WRegistered aircraftS/N 2821056N6897WMcdowell Robert D · Snohomish, WABuilt 1965 · S/N 28-21059N6899FLevel Up Aviation LLC · Newton, ALBuilt 1976 · S/N 28-7725081N68GJDc Foote & Associates Inc · Camarillo, CAS/N 28-7425210N68VCammack Daniel P · Colorado Springs, COBuilt 1967 · S/N 28-4552N6900WHall William Brent · Tulia, TXBuilt 1965 · S/N 28-21063N6905WPodeweltz Wayne L · Merrill, WIBuilt 1965 · S/N 28-21071N6906WStandard American Adjusters Inc · Alba, TXS/N 28-21072N690JTAviationmt LLC · Kalispell, MTS/N 28-7205042N6912WTop Flight Aviation Snh LLC · Savannah, TNBuilt 1965 · S/N 28-21287N6913WAden James D · Gothenburg, NEBuilt 1965 · S/N 28-21288N6914WPearson Timothy M · Waterville, OHBuilt 1965 · S/N 28-21084N6915WOso Air LLC · Missoula, MTBuilt 1965 · S/N 28-21086N6917WCloutier Michael C · Waddell, AZBuilt 1965 · S/N 28-21088N6918WTopping Warren J · Sagaponack, NYBuilt 1965 · S/N 28-21089N6919WN6919w LLC · Key West, FLBuilt 1965 · S/N 28-21090N691FLKelley Keith B · Forney, TXS/N 28-7125628N6922WRobirds Ryan E · Wheelersburg, OHS/N 28-21095N6924WAlpha 3 LLC · Troy, KSBuilt 1965 · S/N 28-21098N6926WCola Air LLC · Irmo, SCBuilt 1965 · S/N 28-21101N6927JClear2fly Aerospace LLC · Daytona Beach, FLBuilt 1976 · S/N 28-7625257N6928WHammons Daniel G · Vadnais Heights, MNBuilt 1965 · S/N 28-21289N6930WFlat Out Aviation LLC · Mercer, MOS/N 28-21105N6933WAlpha 1 Aviation LLC · Helena, ALBuilt 1965 · S/N 28-21110N6934WBenal Charles A · Hastings, NEBuilt 1965 · S/N 28-21111N6936WBergstrom Lindsay B · Plymouth, MNBuilt 1965 · S/N 28-21114N6939WCherokee Eaglefang LLC · New Braunfels, TXBuilt 1965 · S/N 28-21119N693FLBallauer Walter · Remus, MIBuilt 1971 · S/N 28-7125631N693HAHawkins Flight Academy LLC · Shelbyville, TNBuilt 1968 · S/N 28-24178N6942WBobbe Debra M · Paradise Valley, AZBuilt 1965 · S/N 28-21122N6948WCraig Joshua G · Bonaire, GABuilt 1965 · S/N 28-21134N6949WSa Fliers LLC · Venice, FLBuilt 1965 · S/N 28-21138N6950WEalp LLC · Evansville, INBuilt 1965 · S/N 28-21140
Back to AD 96-10-01 R1