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.

N3388SShaffer Barbara J · Franklin, KYBuilt 1969 · S/N 21059188N3388UMenard Charles H · Grand Blanc, MIBuilt 1963 · S/N 18254788N3388YMeeks Peris M · Gardena, CAS/N 18254388N3389DRegistered aircraftBuilt 1955 · S/N 32187N3389MRoberts Roger W Trustee · Wichita, KSBuilt 1989 · S/N CE-1412N3389UThompson Anthony D Trustee · Rockwall, TXS/N 18254789N338BMMorton William · Darby, MTBuilt 1979 · S/N 18267111N338CPQualitair LLC Trustee · MichelstadtBuilt 2008 · S/N 3253N338D38 Delta Corp · Killington, VTBuilt 1987 · S/N E-2392N338DDAltered Dimensions LLC · Noblesville, INBuilt 1980 · S/N 25-0469N338DKUp Top Aviation LLC · Piedmont, CABuilt 2016 · S/N 1461N338HCapital Holdings Fund IV LLC · Boca Raton, FLBuilt 1982 · S/N 18504343N338HPN338hp LLC · Omaha, NEBuilt 1993 · S/N CE-1724N338JFElkins Quentin D · Andersonville, TNBuilt 1957 · S/N D-5401N338LMSisk Stephen A · Greenville, ILBuilt 1968 · S/N 18259244N338MGEjdeha LLC · Boston, MABuilt 1989 · S/N CE-1325N338NSElon Aviation LLC · Burlington, NCBuilt 1974 · S/N TC-1678N338PAFl Ventures I LLC · Winter Park, FLBuilt 2002 · S/N 2844076N338TLMargolis Michael · Ruskin, FLBuilt 1973 · S/N 33701563N338TXBussin' Air LLC · San Antonio, TXBuilt 2023 · S/N 9383N3390FRodgers Christian Joseph · Ormond Beach, FLS/N 18257390N3390YHead John T Jr · Port St Joe, FLS/N 18254390N3391FKingston Terry D · Irving, TXBuilt 1966 · S/N 18257391N3392DHaszard John R · Ophelia, VABuilt 1955 · S/N 32190N3394DCartledge Charles J · Orrville, OHBuilt 1955 · S/N 32192N3394RCurren Patrick V · Green Bay, WIBuilt 1967 · S/N 18258694N3394YNolt Ivan M · Mount Solon, VABuilt 1962 · S/N 18254394N33958Yoalz Inc Trustee · Wilmington, DEBuilt 2025 · S/N 10835N3395DFitzgerald John A Jr · Ester, AKBuilt 1955 · S/N 32193N3395RJohnston Osceola Holdings LLC · Dallas Center, IABuilt 1968 · S/N 18258695N3395YTriple J Aviation · East Quogue, NYS/N 18254395N3396FThompson Patrick J · Evanston, WYBuilt 1966 · S/N 18257396N3396RSimmons Craig · Houston, TXBuilt 1967 · S/N 18258696N3396YPlane Fun Inc · Lewes, DEBuilt 1962 · S/N 18254396N3397FKerns Aaron R · Sullivan, INBuilt 1966 · S/N 18257397N3397GPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1976 · S/N 310R0821N3397QMills Ronald S · South Jordan, UTBuilt 1977 · S/N 28R-7703106N3397RKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1967 · S/N 18258697N3397SMcrae Richard · Kent, WABuilt 1969 · S/N 21059197N3398YBobbitt Michael · Lamont, OKBuilt 1962 · S/N 18254398N3399FVetter T Kevin Trustee · Phoenix, AZBuilt 1966 · S/N 18257399N3399LMetz William · Laurel, MTS/N 185-1351N3399QBaron Aviation Corporation · Broad Run, VABuilt 1975 · S/N 310R0304N3399RGleason Joseph P · Knoxville, TNBuilt 1967 · S/N 18258699N3399UWorley Dan J · Perris, CABuilt 1963 · S/N 18254799N339APParalos Aviation LLC · Penngrove, CABuilt 2020 · S/N 2168N339CDMcwethy22 LLC · Woodstock, GABuilt 2004 · S/N 1107N339CHPitch And Power LLC · Indianapolis, INBuilt 1977 · S/N 18265213N339CPHenley Mark L · Emelle, ALBuilt 1966 · S/N 18257470N339DGRegistered aircraftS/N P21000434
Back to AD 2000-23-21