OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,138

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.

N4154JSzabo Christopher M III · Sprakers, NYBuilt 1966 · S/N 28-22480N41554Flyboys Flight Centers LLC · Griffin, GABuilt 1974 · S/N 28-7425259N4155JCaton John F · Redlands, CAS/N 28-22751N41570Watters James A · Dwight, ILBuilt 1974 · S/N 28-7405120N415CFAlo Fliteline Lc · Waterloo, IABuilt 1975 · S/N 28-7505118N41609Worthington John F II · Russiaville, INBuilt 1974 · S/N 28-7405124N4160JIvy James E · Alba, TXS/N 28-22489N4161JRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1966 · S/N 28-22490N41623Airplanesusa LLC · Schaumburg, ILBuilt 1974 · S/N 28-7405126N4163FHammans Gail A · Hot Springs, ARBuilt 1976 · S/N 28-7725003N4163JLoera Josa · Laredo, TXS/N 28-22493N41645Coastal Air Inc · Groton, CTBuilt 1974 · S/N 28-7405128N4164JCaister Benjamin M · Saint Clair, MIS/N 28-22494N4168JTwigg Donald A · Cumberland, MDBuilt 1966 · S/N 28-22503N416HPKt7 Aviation LLC · Katy, TXBuilt 1963 · S/N 28-1437N416JLCondren Ryan · Sunnyvale, TXBuilt 1967 · S/N 28-23944N41703Sweeny Daniel L · Parrish, FLBuilt 1974 · S/N 28-7405134N4170JMoscrip Mark D · La Vernia, TXS/N 28-22505N4172JAscension Enterprises Inc · Saint Augustine, FLBuilt 1966 · S/N 28-22508N4174JNorth Creek Flying Club Inc · Continental, OHFirst renewal noticeBuilt 1966 · S/N 28-22510N41756N41756 LLC · Upper Marlboro, MDBuilt 1974 · S/N 28-7405140N4175ZKnutson Wayne R · Thompson, NDFirst renewal noticeS/N 28-22170N41774Higher Plane Inc · Ft Lauderdale, FLBuilt 1974 · S/N 28-7425285N41789Flickinger Thomas F · Madison, WIS/N 28-7425287N4178JBennett Jeffrey A · Southgate, MIS/N 28-22515N41792Gwinner Flying Inc · Gwinner, NDBuilt 1974 · S/N 28-7405143N417FLPorter Richard · Round Hill, VABuilt 1971 · S/N 28-7125196N417GGPro Water Solutions LLC · Henderson, TXBuilt 1971 · S/N 28-7125191N417HPKempt Neil H · Canyon Country, CABuilt 1964 · S/N 28-20276N4180JThomason Todd · Harrison, ARS/N 28-22518N4184JGorman Jeffrey M · Ellensburg, WAS/N 28-22523N41859Morale Joseph D · Dallas, TXBuilt 1974 · S/N 28-7405145N4187JPeterson Erik J · Revillo, SDBuilt 1967 · S/N 28-22526N41880Brown Terry K · Eddyville, IABuilt 1974 · S/N 28-7425292N418FLKinney Richard · West Des Moines, IABuilt 1971 · S/N 28-7125197N41901Specht Gilbert E · Downs, KSBuilt 1974 · S/N 28-7405148N41904Gjertsen John W · Quincy, CABuilt 1974 · S/N 28-7425294N4191JVillalba Raymond · Katy, TXBuilt 1966 · S/N 28-22531N41949Ferg Robert B · New London, WIBuilt 1974 · S/N 28-7425301N41963Schafer Gary L · Greenwood, DEBuilt 1974 · S/N 28-7425302N41966Wray Jimmy Don · White House, TNBuilt 1974 · S/N 28-7425303N41973Legacy Aviation LLC · Murfreesboro, TNS/N 28-7405155N41985Aerospace Systems And Training LLC · Orange City, FLBuilt 1974 · S/N 28-7405157N4199JHallenbeck Jesse · Bellingham, WAS/N 28-22543N41AWWalker James A · Birmingham, ALBuilt 1966 · S/N 28-21385N41MSJennings William K · Chandler, AZBuilt 1967 · S/N 28-22716N41ZYBailey Thomas A · Claymont, DES/N 28-3087N4201JYoerg Keith W · Culver City, CAS/N 28-22545N4202JParker Aviation LLC · Camdenton, MOBuilt 1966 · S/N 28-22546N4202TSexton Ronnie K · Clarksville, ARBuilt 1971 · S/N 28-7205090
Back to AD 96-10-01 R1