OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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:87-10-06-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:87-10-06-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.

N322WHThurmond Robert Lee · Blessing, TXBuilt 2024 · S/N HC 094N322ZLafaille David A · Simi Valley, CABuilt 1991 · S/N WP001N32300Primary Flight Control LLC · Fleming Island, FLBuilt 1974 · S/N 28-7515118N32303Eagle Air Solutions LLC · Johnson City, TNBuilt 1974 · S/N 32-7540029N32306Legacy Pilot Training LLC · Annandale, MNS/N 28-7515120N3230FRegistered aircraftBuilt 1967 · S/N 670023N3230QArizona Cassidy E · North Platte, NEBuilt 1977 · S/N 28-7790448N3230TLsao LLC · Shelbyville, ILBuilt 1967 · S/N 17700530N3230WHagan Jackson · Wetumpka, ALBuilt 1965 · S/N 32-40N32314Fort Dodge Flight Support Inc · Fort Dodge, IABuilt 1974 · S/N 28-7525048N32318Feulner Lori · Hebron, NEBuilt 1974 · S/N 28-7515123N3231BEast Martin D · Nicholasville, KYBuilt 1974 · S/N 32-7540030N3231QCollins Gregory J · Appleton, WIBuilt 1977 · S/N 28-7725220N3231RAll2fly LLC · Atlanta, GABuilt 1969 · S/N 28R-31000N3231TGouse Frederick Earl II · Waxahachie, TXBuilt 1967 · S/N 17700531N3231WDouble F Enterprise LLC · Paullina, IABuilt 1965 · S/N 32-42N3231ZWestern Skyways Inc · Montrose, COBuilt 1959 · S/N 22-7176N32321Irvin Phillip Jerry · Winters, TXBuilt 1974 · S/N 28-7515126N32326Blair James J Jr · Brick, NJBuilt 1974 · S/N 28-7525050N32332Warrior 74 LLC · Columbia, SCBuilt 1974 · S/N 28-7515129N32334N32334 Aviation LLC · Chandler, AZBuilt 1974 · S/N 28-7515130N32336Simmer Nicholas Lee · Rock Falls, ILBuilt 1974 · S/N 28-7525052N32337Pab Air Inc · Hialeah, FLBuilt 1974 · S/N 28-7515131N32338Rivera Filiberto Jr · Moses Lake, WABuilt 1974 · S/N 28-7515132N3233FPlank Lester L · Montgomery, INBuilt 1967 · S/N 670026N3233MBoniek Martin J · Glennallen, AKBuilt 1947 · S/N 12-2027N3233WPickens Nathan A · Caldwell, IDS/N 32-45N3233ZGelvin Stanley M · Central, AKBuilt 1959 · S/N 22-7178N32344Cunningham James L · Oshkosh, WIBuilt 1974 · S/N 28R-7535046N32346Voumard Rodney · Turlock, CABuilt 1974 · S/N 28-7510018N32348Ramsey Time LLC · Winter Garden, FLBuilt 1974 · S/N 32-7540032N3234FLastochka LLC · Kalispell, MTBuilt 1967 · S/N 670027N3234LTarrant County College · Fort Worth, TXBuilt 1967 · S/N 27-3626N32351International Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 28-7515134N32353Gardiner Kenneth W · Enfield, MEBuilt 1974 · S/N 28-7515136N32355Finlayson Duncan Robert · Estacada, ORBuilt 1974 · S/N 28-7505053N32357Malone Bernard G · Frenchtown, NJBuilt 1974 · S/N 28R-7535047N3235BHbhis LLC · Gnadenhutten, OHS/N 1010N3235FRosario Michael J · Memphis, TNBuilt 1967 · S/N 670028N32361Odom Eric J · Johnson City, TNBuilt 1974 · S/N 28-7525055N32363Wagner Daniel R · Dewey, AZS/N 28-7515137N32364Buffalo Ridge Aviation LLC · White, SDBuilt 1974 · S/N 28-7515138N32367Martin Stephen · Bonney Lake, WABuilt 1974 · S/N 28-7515139N32369Avia Flight Academy LLC · Stratford, CTBuilt 1974 · S/N 28-7505054N3236PFalcon Air LLC · Anchorage, AKBuilt 1958 · S/N 18-6766N32375Mersereau Austen D · Anchorage, AKBuilt 1974 · S/N 28-7515140N32376Delaware State University · Dover, DEBuilt 1974 · S/N 28-7515141N32378Sanders David D · Alvin, TXBuilt 1974 · S/N 28-7505055N32379Erkert Jason A · Phoenix, AZBuilt 1974 · S/N 28R-7535049N3237NLee Leo Lea Young · Pasadena, CABuilt 1970 · S/N 5849
Back to AD 87-10-06 R1