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.

N9318JJohnson Matt · Eugene, ORBuilt 1966 · S/N 28-3411N9319JAcs Aviation LLC · Wilmington, DEBuilt 1966 · S/N 28-3427N9321JR Goldburg LLC · Gastonia, NCBuilt 1966 · S/N 28-3414N9322JZollitsch Allan P · Lancaster, NYBuilt 1966 · S/N 28-3415N9323JDaissaoui Anouar · Quincy, MABuilt 1966 · S/N 28-3416N9324JAdbdelsalam Moustafa · Buena Park, CABuilt 1966 · S/N 28-3417N9328JRegistered aircraftBuilt 1966 · S/N 28-3422N9329JBradford Earl · Fairview, MIFirst renewal noticeBuilt 1966 · S/N 28-3423N9330JTinaga Resorts Corp · San Angelo, TXS/N 28-3424N9331JSkysight Consulting LLC · Memphis, TNBuilt 1966 · S/N 28-3428N9332JKnutson Wayne R · Thompson, NDBuilt 1966 · S/N 28-3429N9333JRau Alan · Java, SDBuilt 1966 · S/N 28-3430N9337JHudson Kenneth J · Caswell Beach, NCBuilt 1966 · S/N 28-3434N9337KSkyrise Aviation Corp · Pompano Beach, FLBuilt 1976 · S/N 28-7625176N9338JCarr Shelby · Stevenson, ALBuilt 1966 · S/N 28-3435N9339JTruesdell Michael L · Tonopah, NVS/N 28-3436N933BKKreul Robert W · Waconia, MNBuilt 1971 · S/N 28-7225113N9340JLovelace Mario · Coral Springs, FLBuilt 1966 · S/N 28-3438N9342JDeschepper Sandra K · Independence, MOBuilt 1966 · S/N 28-3440N9344JBiamonte Thomas John · Ventura, CABuilt 1966 · S/N 28-3442N9345JGrady John O · West Chester, OHBuilt 1966 · S/N 28-3443N9346JAhern Walter B · Durango, COBuilt 1966 · S/N 28-3444N9349JPfingsten Leon R · Sheldon, NDBuilt 1966 · S/N 28-3447N9350JElliott Peter J · Riverside, CABuilt 1966 · S/N 28-3448N9351JCoyote Flight Centers LLC · Amarillo, TXBuilt 1966 · S/N 28-3449N9352JDiorio Robert A · Redlands, CABuilt 1966 · S/N 28-3450N9353JNychka Robert J · Wills Point, TXBuilt 1966 · S/N 28-3451N9354JLamb David S · Yuba City, CABuilt 1966 · S/N 28-3453N9356JVali Air Service LLC · Livingston, MTBuilt 1966 · S/N 28-3455N9357JKirchoff Jennifer L · Hamden, CTBuilt 1966 · S/N 28-3456N9362JSandy Bottom LLC · Nantucket, MABuilt 1966 · S/N 28-3461N9364JBerthiaume Richard R · Millbury, MAS/N 28-3463N9365JTrujillo Mark A · Corvallis, ORBuilt 1966 · S/N 28-3464N9365KSchlecht Erich T · Pasadena, CABuilt 1976 · S/N 28-7625177N9366JDnr Aircraft LLC · Mesa, AZBuilt 1966 · S/N 28-3465N9368JPierce Cale G · Fort Walton Beach, FLBuilt 1966 · S/N 28-3467N9369JIcarus And Son LLC · Wilmington, DEBuilt 1966 · S/N 28-3468N9371JBosker John A · South Bend, INBuilt 1966 · S/N 28-3470N9372JReed Theodore W III · Trinidad, COBuilt 1966 · S/N 28-3471N9375JPanjab Aviation Inc · Las Vegas, NVBuilt 1966 · S/N 28-3474N9376JMorales Michael · Pembroke Pines, FLBuilt 1968 · S/N 28-5121N9377JDruetzler Thomas · Lynwood, ILBuilt 1966 · S/N 28-3476N9378JBentley Aero LLC · La Farge, WIBuilt 1966 · S/N 28-3477N9379JDurango Air Services LLC · Wilmington, DES/N 28-3478N9380JMay Theodore R · Mcloud, OKBuilt 1966 · S/N 28-3480N9381J2208 Juliet Inc · Redwood Falls, MNBuilt 1966 · S/N 28-3733N9383JBarrowman John L · Tucson, AZBuilt 1966 · S/N 28-3483N9384JCrayviation LLC · Leesburg, VABuilt 1966 · S/N 28-3484N9385JDauzat Robbie A · Pineville, LABuilt 1966 · S/N 28-3485N9386JWilkes Flying Club Inc · Wilkesboro, NCBuilt 1966 · S/N 28-3486
Back to AD 96-10-01 R1