OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N3516YMks Aviation LLC · Port Orchard, WABuilt 1962 · S/N 18254416N3517AMunoz Pedro L · Ontario, NYBuilt 1969 · S/N TC-1305N3517YRobles Serafin M · Cynthiana, KYBuilt 1962 · S/N 18254417N3518FPortmann James R · St Louis Park, MNBuilt 1966 · S/N 18257518N3518YMcaninch Shawn R · Albia, IAFirst renewal noticeBuilt 1962 · S/N 18254418N3519YWeber Larry F · New Paltz, NYBuilt 1962 · S/N 18254419N351ABTropical Transport Services Ltd · San Juan, PRBuilt 1980 · S/N 402C0351N351ATRegistered aircraftBuilt 1967 · S/N D-8507N351CDRegistered aircraftBuilt 2026 · S/N 11184N351HCBig Elk Aviation LLC · Elk City, OKS/N 414A0801N351JPParker Robert · Oklahoma City, OKBuilt 1976 · S/N TJ-51N351KAByrnes Leasing Inc · Wilmington, DEBuilt 2008 · S/N 411095N351PLifted Six Aviation LLC · Wilmington, DEBuilt 1962 · S/N D-6919N351PKK-Air Inc · Egg Harbor, WIBuilt 2025 · S/N 10857N351PLBender Cliff · Plano, ILBuilt 1964 · S/N D-7302N351RRHolder Joiy R · Port Saint Lucie, FLBuilt 1964 · S/N TC-763N351RSSmith Herschel W III Md · Roswell, GABuilt 1966 · S/N D-8299N351SREagle I LLC · Kalispell, MTBuilt 2009 · S/N 3571N351TWLlorca5 LLC · Bradenton, FLBuilt 2025 · S/N 10597N351VBWudtke Dale A Trustee · Palos Park, ILBuilt 1970 · S/N D-9207N351VKFly Amelia LLC · Montclair, NJBuilt 2019 · S/N 1905N351XSpeer Thomas Edward · Farmington, UTS/N 6169CN351ZDofka Martin F III · Wheeling, WVBuilt 1960 · S/N CD-237N3520FWood Forrest B · Cookson, OKBuilt 1966 · S/N 18257520N3520USchioppo Joseph · Boynton Beach, FLBuilt 1963 · S/N 18254920N3520VHarrell Erick C · Sedona, AZBuilt 1977 · S/N R1722256N3521YSportsman Airpark Inc · Newberg, ORS/N 18254421N3522RCypret Craig P · Kingston, NHBuilt 1965 · S/N M-681N3522UDfs · Bountiful, UTBuilt 1963 · S/N 18254922N3522YBohlen Thomas R · Hudson, WIBuilt 1962 · S/N 18254422N3523UCharlson Aaron H Jr · Forest City, IABuilt 1963 · S/N 18254923N3524UHudson George R · Hueytown, ALBuilt 1963 · S/N 18254924N3525FR&R Aviation · Gunnison, COBuilt 1966 · S/N 18257525N3526ARoeder Miles · Houston, TXBuilt 1969 · S/N D-9075N3526FHaskett Steven E · Austin, TXBuilt 1966 · S/N 18257526N3526UThomason Tommy Eugene Trustee · Scottsdale, AZBuilt 1963 · S/N 18254926N3527FTuorila Tony C · Anderson, SCBuilt 1966 · S/N 18257527N3527YHrobak Robert F · Winter Garden, FLBuilt 1963 · S/N 18254427N3528FFair Paul R · Vacaville, CABuilt 1966 · S/N 18257528N352JAPeterson Erik · Zeeland, MIBuilt 2008 · S/N 421005N352JSMccormick Kevin · Douglass, TXBuilt 2006 · S/N 42507N352KPN258wt LLC · Boca Raton, FLBuilt 2019 · S/N 4845N352LBurdick Rich · Montrose, COBuilt 1958 · S/N 35769N352MBD&D Aviation LLC · Brandon, MSBuilt 2025 · S/N 11074N352MMWindmill Aviation LLC · Sleepy Hollow, NYBuilt 2021 · S/N 5096N352MRN352mr LLC · Weldona, COBuilt 2006 · S/N 1782N352MSRoehrig Bradley · Webster, NYBuilt 2007 · S/N 1802N352QWingstodieu LLC · Charlotte, NCBuilt 2025 · S/N 10967N352RCN352rc Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0186N352RHHackler Russell W Jr · Livermore, CABuilt 1964 · S/N D-7562
Back to AD 2000-23-21