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.

N415VWDrago Christopher P · Flint, MIBuilt 1964 · S/N TC-811N415WBCanon Robert G · Waller, TXBuilt 2015 · S/N 4296N415WMFour Wynns Aviation Llp · Stansbury Park, UTBuilt 1999 · S/N 1005N415WZCrimson Leasing LLC · Lenexa, KSBuilt 1978 · S/N 340A0602N4161AKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2000 · S/N 3449160N4162SFiresheets William R · Zwolle, LABuilt 1975 · S/N CE-568N4163ASalida Aviation Partnership Group · Moffat, COBuilt 1970 · S/N D-9121N4163SLarson Family Farms LLC · Haxtun, COBuilt 1975 · S/N E-664N4163TKasper Heath · Albany, ORS/N 320D0063N4164SFabien Turpaud Corp · Lewes, DEBuilt 1975 · S/N D-9753N4165BGood Decision Aviators LLC · Noble, OKBuilt 1975 · S/N 76-30799N4165QGhiselli William A III · Woodruff, WIBuilt 1968 · S/N 310N-0065N4165S5100 Departure LLC · Beaufort, NCBuilt 1975 · S/N TE-1049N4166QMays Kevin E · West Liberty, KYS/N 310N-0066N4166SBurgess Stephan H · Nags Head, NCBuilt 1975 · S/N CE-569N4167GW J Medical Consulting · Caguas, PRBuilt 1976 · S/N 402B1214N4167PAeroplace Services Inc · Denison, TXBuilt 1965 · S/N TF-23N4167QHawkeye Helicopter LLC · Lyndon, KSBuilt 1968 · S/N 310N-0067N4168DAnanas Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 3449158N4168TTan Resources LLC · Bondurant, IABuilt 2000 · S/N 3449166N4169QMarasovich Christopher · Youngstown, OHBuilt 1968 · S/N 310N-0069N4169SHp Aero Vantage LLC · Sand Springs, OKBuilt 1975 · S/N CE-570N4169YVanderhoof Chad T · Elk, WAS/N 185-0369N416BRSeiler Valerie K Trustee · Hoffman Estates, ILBuilt 1987 · S/N CE-1187N416CDLewis Jim C · Tigard, ORBuilt 2006 · S/N 1820N416CERedwing Aviation LLC · Largo, FLBuilt 2019 · S/N 4782N416DMcginnis Aviation LLC · Kentwood, MIBuilt 1974 · S/N TH-500N416GWidhalm Chelsea · Yakima, WABuilt 2002 · S/N 0310N416GFHahn Steven P · Hutchinson, MNBuilt 1964 · S/N D-7497N416JSC Randy Landis Dds Inc · Oroville, CABuilt 1973 · S/N TH-416N416LALambourne Holdings LLC · Incline Village, NVBuilt 2021 · S/N 2480N416MKSmith Jason · Cresson, TXBuilt 1967 · S/N TE-426N416PCKjt Aviation LLC · Beaumont, TXBuilt 2016 · S/N 4329N416RARegistration Pending · Muskegon, MIRegistration pendingBuilt 1980 · S/N 414A0486N416SCribbie Ronald J Trustee · Hernando, FLBuilt 2001 · S/N 0020N416TKehoe Keith J · Marion, TXBuilt 1961 · S/N CD-282N416TBMyers Hollis Donald III · Lexington, NCBuilt 2005 · S/N 42080N416TDC C Aviation Group LLC · Wilmington, DEBuilt 2009 · S/N 3398N416TXVolo 2020 LLC · New Britain, CTBuilt 2013 · S/N E-3997N416USClepper Francis D Jr · Bennington, NEBuilt 2006 · S/N 29-0416N416WBSoaring Eagle Air LLC · Salt Lake City, UTBuilt 2007 · S/N 2540N4170Nogle Charles J · Champaign, ILBuilt 1964 · S/N G-270N4170HBridges Kevin J · Clemmons, NCBuilt 2002 · S/N 3449259N4171QN4171q LLC · Newport Beach, CABuilt 1972 · S/N 340-0094N4171SSteffey Kevan J · Bullhead City, AZFirst renewal noticeBuilt 1975 · S/N E-667N4172SWharton Roofing Services LLC · Gulf Breeze, FLBuilt 1975 · S/N CE-571N4173BBeck Nicholas G · Ione, CABuilt 1975 · S/N 75-30792N4174DB L Duke Inc · Joliet, ILBuilt 2000 · S/N 3449178N4175QKabat Jules M · Las Vegas, NVBuilt 1968 · S/N 310N-0075N4175SBauman Loren A · Lewisville, NCS/N D-9756
Back to AD 2000-23-21