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.

N9242JCoyote Flight Centers LLC · Amarillo, TXBuilt 1966 · S/N 28-3316N9243JRoney Edward A · Weirton, WVBuilt 1966 · S/N 28-3318N9244JRichardson David M · Dwight, ILS/N 28-3319N9246JMckool John Jr · Johnstown, PABuilt 1966 · S/N 28-3321N9247JGreco Timothy F · Sewell, NJBuilt 1966 · S/N 28-3322N924DBFlying Veterans Club Of San Francisco Inc · Belmont, CABuilt 1973 · S/N 28-7305198N924KAEvanoff Mark Alan · Saint Augustine, FLBuilt 1965 · S/N 28-21295N9251JGholami Amir K · Santa Rosa, CABuilt 1966 · S/N 28-3326N9252JFlying Wrenches LLC · Cairo, NEBuilt 1966 · S/N 28-3327N9257JWojtecki Chris R · Florissant, COBuilt 1966 · S/N 28-3333N9258JHummingbird Avaition LLC · Columbus, INBuilt 1966 · S/N 28-3334N9259JDave Flight LLC · Mccook, NEBuilt 1966 · S/N 28-3335N925MKOates Douglas E · Elgin, SCBuilt 1966 · S/N 28-3325N9261JLear Steven J · Rockville, INBuilt 1966 · S/N 28-3337N9263JHarrod Andrew A Jr · El Segundo, CABuilt 1966 · S/N 28-3339N9265JStuvland Christopher · Pendleton, ORBuilt 1966 · S/N 28-3341N9266JTaccone Glenn R · Henderson, NVBuilt 1966 · S/N 28-3343N9267JLarson Christopher J · Saint Maries, IDBuilt 1966 · S/N 28-3344N9268JRegistered aircraftBuilt 1966 · S/N 28-3345N9269JHelm Daniel E · Portland, ORBuilt 1966 · S/N 28-3346N926MKToothman John C · Fairmont, WVBuilt 1971 · S/N 28-7125138N9272JEast Fork Flyers LLC · Lu Verne, IABuilt 1966 · S/N 28-3350N9273JWhite Raymond · Jasper, ARBuilt 1966 · S/N 28-3351N9274JLund Christian W · New Ipswich, NHBuilt 1966 · S/N 28-3352N9275JLow Country Flight Company LLC · Savannah, GAS/N 28-3353N9278JMcbride Gary J · Niantic, CTBuilt 1966 · S/N 28-3357N927TMGmr Leasing LLC · Lincoln, DES/N 28-21102N9280JLone Star Steel Structures LLC · Kaufman, TXS/N 28-3359N9283JN9283j LLC · Boise, IDBuilt 1966 · S/N 28-3363N9285JCope Jarret C · Lexington, NCS/N 28-3369N9288JMccormack John P · New Castle, INS/N 28-3373N9290JRodgers Bruce F · Quakertown, PABuilt 1966 · S/N 28-3375N9291JMidwest Aero Club Inc · Omaha, NEBuilt 1966 · S/N 28-3377N9293JChaldu Ronald S · Oswego, NYBuilt 1966 · S/N 28-3381N9295JKohn Brent A · Spring Valley, MNS/N 28-3385N9296JAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1966 · S/N 28-3386N9299JLucas Steven R · Canton, OHBuilt 1966 · S/N 28-3389N92CZBluebirdaero Inc · Magnolia, TXBuilt 1968 · S/N 28-25276N92FBBauer Aviation LLC · St Germain, WIBuilt 1969 · S/N 28-5321N9300JRoberts Raymond R · Independence, MOBuilt 1966 · S/N 28-3391N9301JN9301j LLC · Reno, NVBuilt 1966 · S/N 28-3392N9305KHitech Aerospace Corp · New York, NYBuilt 1976 · S/N 28-7625175N9306JHanna Jr Charles W · Kingstree, SCBuilt 1966 · S/N 28-3398N9307JWilliams Austen T · Fort Worth, TXBuilt 1966 · S/N 28-3399N9308JYoung Ashley G · Lexington, NCBuilt 1966 · S/N 28-3400N9310JBuckwalter Russell · Broadway, VABuilt 1966 · S/N 28-3403N9311JSentelle Amanda L · Frederick, MDBuilt 1966 · S/N 28-3404N9313JLockhart Michael B · Redlands, CABuilt 1966 · S/N 28-3406N9315JKruthoff Bret · Charles City, IABuilt 1966 · S/N 28-3425N9316JStennis Aviation Group LLC · Mandeville, LABuilt 1966 · S/N 28-3409
Back to AD 96-10-01 R1