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.

N9723JRegistered aircraftBuilt 1967 · S/N 28-3915N9725JSturgeon Aviation LLC · Ellijay, GABuilt 1967 · S/N 28-3917N9726WSarratt Curtis H · Annapolis, MDBuilt 1967 · S/N 28-23204N9727JJdc Aviation LLC · Upland, CABuilt 1967 · S/N 28-3920N9727WGrinter Mark R · Highland, ILS/N 28-23205N9729WArtesian Hills Aviation LLC · Twin Lake, MIBuilt 1967 · S/N 28-23207N972CAKleinschnittger Steven J · Alton, ILBuilt 1966 · S/N 28-3209N9731WDacy David M · Harvard, ILBuilt 1967 · S/N 28-23210N9732JWalborn Gary D · Youngstown, OHBuilt 1967 · S/N 28-3925N9732WFlying Elvis · Jacksonville, FLBuilt 1967 · S/N 28-23212N9733WWilson Lyndon K Sr · Ringgold, GAS/N 28-23214N9734JPiper Perfect LLC · Panama City, FLBuilt 1967 · S/N 28-3927N9734WNimbus Air LLC · Frankfort, ILS/N 28-23215N9737WAzzurra City Tours LLC · Staten Island, NYBuilt 1967 · S/N 28-23219N9738WBendigo Paul L · Reading, PABuilt 1967 · S/N 28-23220N9739JSullins Drew Preston · Woodstock, MDBuilt 1967 · S/N 28-3933N973TMAnders Andrew C · Lansdale, PABuilt 1972 · S/N 28-7205254N9740JSpasiano Kyle P · Camarillo, CABuilt 1967 · S/N 28-3934N9740WD14 Flight Club Inc · Manteno, ILBuilt 1967 · S/N 28-23222N9741JSchulte Lance D · East Dundee, ILBuilt 1967 · S/N 28-3936N9742JBores Scott J · Huron, OHS/N 28-3937N9742WThurmond Donald · Madison, GAS/N 28-23224N9743JMcmurry Patric R · Casper, WYBuilt 1967 · S/N 28-3939N9743WFoster Jay W · Marshfield, MOBuilt 1967 · S/N 28-23225N9744JMerrick Christina L · Sylmar, CABuilt 1967 · S/N 28-3940N9745JLakeview Aviation LLC · Great Barrington, MABuilt 1967 · S/N 28-3941N9745WMadi Mohammed Nashat Ibrahim · Charlotte, NCBuilt 1967 · S/N 28-23227N9746JJet Air Inc · Iowa City, IABuilt 1967 · S/N 28-3942N9746WRegistered aircraftBuilt 1967 · S/N 28-23229N9747JThomas Daniel S · Willow, AKBuilt 1967 · S/N 28-3943N9747WAustin Christopher W · Dayton, NVBuilt 1967 · S/N 28-23230N9748JReynolds John J · Howell, MIBuilt 1967 · S/N 28-3946N9748WWest David · Astoria, ORBuilt 1967 · S/N 28-23231N9749JNoth Christopher A · Seminole, FLBuilt 1967 · S/N 28-3935N9750JBaltz Aviation Services LLC · Mercer, WIBuilt 1967 · S/N 28-3897N9751JR&A Aviation LLC · Flower Mound, TXBuilt 1967 · S/N 28-3944N9753WSeppala Matthew T · Hortonville, WIS/N 28-23236N9755JDesroches John · Scottsdale, AZS/N 28-3947N9755WAncheta Kai A · Anchorage, AKBuilt 1967 · S/N 28-23239N9756JJackson Robert L · Leesburg, VABuilt 1967 · S/N 28-3948N9757JCarbiener Diane M · Kewanee, ILBuilt 1967 · S/N 28-3949N9757WTld And Company LLC · Trenton, FLBuilt 1967 · S/N 28-23241N9758JKiarsis Stephen G · West Wareham, MABuilt 1967 · S/N 28-3950N9759JLazy H LLC · Carleton, NEBuilt 1967 · S/N 28-3951N9760JHanks Cathy J · Danville, KYBuilt 1967 · S/N 28-3953N9760WRegistered aircraftBuilt 1967 · S/N 28-23244N9761WRivera-Osorio Karolina · Monroe, NYS/N 28-23245N9763JShaffer Timothy R · Marion, IABuilt 1967 · S/N 28-3958N9764WMich John D · Fort Morgan, COBuilt 1967 · S/N 28-23250N9765JPinson Cassandra · Chandler, AZBuilt 1967 · S/N 28-3960
Back to AD 96-10-01 R1