OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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.

N3151FBentley Nicholas Klausing · Reading, PABuilt 1966 · S/N 18257251N3151JStava Robert D · Brainard, NEBuilt 1980 · S/N T18803609TN3151QRairdan Todd G · Vacaville, CABuilt 1967 · S/N 18258151N3151SThomas Darryl · Belfield, NDBuilt 1964 · S/N 18255651N3151YVert James E · Davison, MIBuilt 1962 · S/N 18254151N31526Trostel Manfred E · Longboat Key, FLBuilt 1989 · S/N E-2487N3152ERegional Medical Consulting Pllc · Mebane, NCBuilt 1994 · S/N E-2880N3152FJk Aviation LLC · Warden, WABuilt 1966 · S/N 18257252N3152QFff Aviation LLC · Land O Lakes, FLS/N 18258152N3152SDavis Lee W · Burns, ORFirst renewal noticeBuilt 1964 · S/N 18255652N31530Wheeler Auctions & Real Estate LLC · Paris, MOBuilt 1978 · S/N 34-7870238N3153BSeverson James A Jr · Tualatin, ORBuilt 1983 · S/N P21000834N3153CCulver Marc D · Anchorage, AKBuilt 1954 · S/N 30952N3153DN3153d LLC · Middletown, DEBuilt 1955 · S/N 31951N3153KKansas Aviation Museum · Wichita, KSS/N 2N3153LMiller James R · Parowan, UTBuilt 1965 · S/N 310J0153N3153PWhiskey Mike Aviation LLC · Merrimac, WIBuilt 1994 · S/N E-2884N3153QMaine Mold & Machine Inc · Hartford, MEBuilt 1967 · S/N 18258153N3154CMitchell Barry C · Sagle, IDBuilt 1954 · S/N 30953N3154DJohnson Daniel P · Pardeeville, WIS/N 31952N3154FMetcalf Management Inc · St George, UTBuilt 1994 · S/N EA-564N3154LOnisko Aidan C · Williams, CAS/N 310J0086N3154RKuchera Ray A · Rockdale, TXBuilt 1967 · S/N 18258554N3155CNolan Michael William Jr · Silver Spring, MDBuilt 1954 · S/N 30954N3155DNervino Blake · Turlock, CABuilt 1955 · S/N 31953N3155FHansen Jeremy · Burlington, COBuilt 1966 · S/N 18257255N3155QLandro Rebecca · Puyallup, WAS/N 18258155N3155REnright Matthew R · Skiatook, OKBuilt 1967 · S/N 18258555N3156CMarshall Robert L · Pine River, MNBuilt 1954 · S/N 30955N3156RChamplain Robert F · Canton, ILBuilt 1967 · S/N 18258556N3156XBack Country Aviation LLC · Jupiter, FLS/N 20700376N3156YGrant Robert N · Pollock Pines, CABuilt 1962 · S/N 18254156N3157QVowell Gregory · Coffeyville, KSBuilt 1967 · S/N 18258157N3157UDavison Cornelius Harry Jr · Phoenix, AZBuilt 1962 · S/N 18254557N3158FTw Enterprises Inc · Naperville, ILBuilt 1966 · S/N 18257258N3158RHelms Stephen G · Anchorage, AKBuilt 1967 · S/N 18258558N3158SBr Aviation LLC · Lewes, DES/N 18255658N31595Highlander Air LLC · Kalispell, MTBuilt 1978 · S/N 34-7870243N3159FYarbrough Chad · Bloomingdale, GABuilt 1966 · S/N 18257259N3159RSdmg Signs LLC · Las Vegas, NVS/N 18258559N315ABColabianchi Bob J · Fountain Hills, AZBuilt 1975 · S/N D-9740N315AGAlpert Adam L · Delray Beach, FLBuilt 1981 · S/N 18053196N315AHHorizon Aviation Holdings LLC · Fort Lauderdale, FLBuilt 2019 · S/N 4789N315ARKeller Joseph George · Melbourne, FLBuilt 2007 · S/N 1860N315BCasteel Robert C DBA · Elk Grove, CABuilt 1956 · S/N D-4866N315BPKing Logistics LLC · Ridgeland, MSBuilt 1979 · S/N TC-2230N315CACirrus Middle East Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11466N315CDFranklin Clinton · Edmond, OKBuilt 2004 · S/N 0947N315CEAddonizio Victor Paul III · Long Island City, NYBuilt 2011 · S/N 0111N315CKMarket-Partners Inc · Santa Rosa, CABuilt 2009 · S/N 3413
Back to AD 2000-23-21