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.

N2363TKan-Do Inc · Danbury, CTBuilt 1961 · S/N NAV-4-2363N2363XShort Joe · Clintwood, VABuilt 1965 · S/N 18256263N23642Samson Motors Inc · Redmond, ORBuilt 1977 · S/N CE-759N2364CMeinershagen Charles I · Redding, CABuilt 1953 · S/N 30664N2364FCarlson David G Trustee · Cape Fair, MOBuilt 1964 · S/N 21058564N2364GTveitnes Svein T · Whitewright, TXBuilt 1958 · S/N 51664N2364RRegistered aircraftBuilt 1964 · S/N 18255464N2364XElkhorn Aviation LLC · Norfolk, NEBuilt 1965 · S/N 18256264N2365TTodd John R · Flower Mound, TXBuilt 1962 · S/N NAV-4-2365N2366CKase Gayle L · Wasilla, AKBuilt 1953 · S/N 30666N2366EWerner Service & Trucking Inc · Saint Edward, NEBuilt 1982 · S/N 18268197N2366SDaughtrey Kevin E · Arcadia, FLS/N 337-0666N23674Siebenhaar Harold J · Los Altos, CAS/N D-10146N2367GSahagun Salvador G · Bothell, WAS/N 51667N2367PCrowley Steven J · Burlington, IABuilt 1981 · S/N TC-2367N2367THunsaker Matthew L · De Pere, WIBuilt 1961 · S/N NAV-4-2367N23682Next Century Aviation Oregon LLC · Sausalito, CABuilt 1978 · S/N E-1205N23685Clements Dennis · Chapel Hill, NCBuilt 1978 · S/N D-10099N2368XD C T LLC · Wallace, IDBuilt 1965 · S/N 18256268N2369CBlackert Charles M · Delaware Water Gap, PABuilt 1954 · S/N 30669N2369GPeter Travis E · Casper, WYBuilt 1958 · S/N 51669N236AMyotis Ltd · Leesburg, VABuilt 1973 · S/N 18262695N236ATN236at LLC · Miami, FLBuilt 1975 · S/N 414-0805N236BBLpb Aviation LLC · Austin, TXBuilt 2023 · S/N 9366N236BEMcgill Benjamin D · Larchmont, NYBuilt 1981 · S/N E-1825N236CBCarlson Aviation LLC · Dubois, PABuilt 2021 · S/N 2336N236CFGriswold Joshua P · Los Angeles, CABuilt 1976 · S/N 34-7770091N236CHGta Air Inc · Addison, TXBuilt 1973 · S/N E-502N236CTCostanzo Ralph R · Virginia Beach, VABuilt 1968 · S/N E-51N236DCGilbert Gerald · Falls Church, VABuilt 2012 · S/N 3836N236DRVargyas Aviation LLC · Michigan City, INBuilt 2017 · S/N 1620N236GDimartino Richard · Port Jefferson, NYBuilt 2005 · S/N E-3638N236HPProctor John M · Spotsylvania, VABuilt 1987 · S/N E2399N236JEGunnels Farms Inc · Amarillo, TXS/N TC-2092N236JPLauderdale Thomas J · Bates City, MOBuilt 1970 · S/N E-211N236LLaux Air LLC · Missoula, MTBuilt 2004 · S/N 0810N236LLFrenjc LLC · Sedona, AZBuilt 2002 · S/N L2K-158N236MCameron Mark D · Alpine, WYBuilt 1965 · S/N 292N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116N236RMConrad Harold M · Sugar Grove, ILBuilt 1979 · S/N EA-43N236RSSchoombee Clinton John · Murrieta, CABuilt 2004 · S/N 41003N236STOutdoor Metal Products LLC · Leighton, ALBuilt 1968 · S/N 401A0020N236TCCka Investments LLC · Fernandina Beach, FLBuilt 1979 · S/N EA-23N236WBt1 Air LLC · Grover Beach, CABuilt 2002 · S/N E-3432N2370GJ H Nicklas Inc · Cartersville, GABuilt 1958 · S/N 51670N2370TR Douthitt Enterprises Inc · El Centro, CAS/N NAV-4-2370N23714Dyk Aviation LLC · Williston, NDBuilt 1978 · S/N E-1206N23717Advanced Helicopter Services · Woodland, CABuilt 1978 · S/N E-1208N2371CMathers John R · Denton, TXBuilt 1953 · S/N 30671N2371RBudell Stacey M · Caldwell, IDBuilt 1964 · S/N 18255471
Back to AD 2000-23-21