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.

N945DSKnox Matthew · New Carlisle, OHBuilt 1962 · S/N 28-620N9460JDerosa Michael D · Hewitt, TXBuilt 1966 · S/N 28-3573N9461JKobbeman Joseph B · Louisville, KYBuilt 1966 · S/N 28-3574N9464JReinert Roger J · Duluth, MNS/N 28-3578N9465JTaylor Robert J · Woodbridge, VABuilt 1966 · S/N 28-3579N9466JHawk Aviation Academy LLC · Saint Petersburg, FLBuilt 1966 · S/N 28-3580N9468JSheffield Glenn A · Houston, TXBuilt 1966 · S/N 28-3582N9469JNelson Stephen A · Milaca, MNBuilt 1966 · S/N 28-3584N9472JMarquette County Flying Club · Marquette, MIBuilt 1966 · S/N 28-3587N9473JEncounter Inc · Piedmont, OKBuilt 1966 · S/N 28-3588N9474JGerber Dennis J · Liverpool, NYBuilt 1966 · S/N 28-3589N9476JNery Thomas A · Mansfield, MABuilt 1966 · S/N 28-3592N9477JMatthews Byron Kim · Hooper, UTS/N 28-3593N9480J217 Moriarty LLC · Stonewall, MSBuilt 1966 · S/N 28-3597N9481JRuffner Samuel D · Powder Springs, GABuilt 1966 · S/N 28-3598N9485JBlakely Jerry II · Coeur D Alene, IDBuilt 1966 · S/N 28-3602N9486JJames Andy K · Shallowater, TXBuilt 1966 · S/N 28-3603N9487JElmenhurst Daniel D · Walla Walla, WABuilt 1966 · S/N 28-3604N9488JSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 28-3605N9489JIndiana County Flying Club Inc · Blairsville, PABuilt 1966 · S/N 28-3606N9491JRoy Thomas M Jr · Carbondale, ILBuilt 1966 · S/N 28-3609N9493JHayes Enterprises · Glendale, AZBuilt 1966 · S/N 28-3611N9494JRuiz Serge · Montgomery, TXS/N 28-3613N9497JShushnar Gary J · Irvine, CABuilt 1966 · S/N 28-3737N9498JBrantley Hugh L · Hazlehurst, GAS/N 28-3738N95008Ottaway Brent E · Derby, KSBuilt 1969 · S/N 28-25775N9500JMidwest Air Freight LLC · Sioux City, IABuilt 1966 · S/N 28-3620N9500WRachel Calvin · Kimberly, ALS/N 28-22921N9501JKnutson Donald W · Litchfield, MNBuilt 1966 · S/N 28-3621N9502WHellevang Ryan K · Duvall, WAS/N 28-22924N9503WLoya Armando · Whittier, CAS/N 28-22925N95044Mach Point Two Aviation LLC · Conroe, TXBuilt 1969 · S/N 28-25783N9504WS&J Aviation LLC · Burlington, WABuilt 1967 · S/N 28-22926N95053Jamesweathers Robi J · Blaine, MNBuilt 1969 · S/N 28-25788N9505JConnors Paul J II · Murrieta, CABuilt 1966 · S/N 28-3626N95063Dugan Jason · Wellington, TXBuilt 1969 · S/N 28-25794N95069Tower Aviation Of Reading Inc · Reading, PABuilt 1969 · S/N 28-25797N9506JEspinal Branhder · Union, NJBuilt 1966 · S/N 28-3627N95071Lund Jonathan J · Glencoe, MNBuilt 1969 · S/N 28-25798N95080Johnson Patrick W · Toney, ALBuilt 1969 · S/N 28-25800N95084Lyons Nathaniel R · Fort Scott, KSBuilt 1969 · S/N 28-25801N95089Moll Michael J II · Mechanicville, NYBuilt 1969 · S/N 28-25804N9508JGandas Aero Inc · Eagan, MNS/N 28-3629N95091Jts Aircraft LLC · Rock Hill, SCBuilt 1969 · S/N 28-25805N9509JStevens Sheldon D · Clark, SDBuilt 1966 · S/N 28-3630N95105Airbud Aviation LLC · Morristown, NJBuilt 1969 · S/N 28-25806N95111Tiny Tin Aviation LLC · Groveland, FLBuilt 1969 · S/N 28-25808N9511JGomez Alexandro · Riverside, CABuilt 1966 · S/N 28-3633N9511KMoore Matt R · Nashville, TNS/N 28-7625182N95121Preston Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28-25814
Back to AD 96-10-01 R1