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.

N281CPJust Plane Insane LLC · Missouri City, TXBuilt 2008 · S/N 3181N281DSBoughton Kyle · Mckinleyville, CABuilt 2007 · S/N 2534N281JPPrince Jeffrey S · Mckinney, TXBuilt 1999 · S/N 30-0021N281MFFisher Robert · Durham, NCBuilt 2025 · S/N 10441N281MGCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 9771N281PBMartin Robert F Jr · Fort Deposit, ALBuilt 1963 · S/N D-7255N281RWalker Lawrence J · Haymarket, VABuilt 1964 · S/N TC-757N281RCCavett Richard A · Enderlin, NDBuilt 1973 · S/N 74-30619N281RMHolthaus Craig J · Canton, ILBuilt 1979 · S/N 25-0059N281STucker Daniel · Weatherford, TXBuilt 1968 · S/N TE-566N281SLCurly Aviation LLC · Atlanta, GABuilt 1972 · S/N 182-61394N281SRLawyers Real Estate Services LLC · Hondo, NMBuilt 2007 · S/N 2810N281SVOlson Fred · Harrison, ARBuilt 2000 · S/N 00-301029N281TMalerba David · Morrison, COBuilt 1967 · S/N D-8508N281TBJorgensen Carl · Boerne, TXBuilt 2008 · S/N 001N281UDStanley David Wayne · Burleson, TXBuilt 1981 · S/N P21000690N281VBarry Larry M · Woodbine, IAS/N D-8195N282Sh1p Holdings LLC · Wichita, KSBuilt 2023 · S/N 9446N28201Viking 28201 LLC · El Dorado Hills, CABuilt 1978 · S/N 78-30903N28208Registered aircraftAssigned, pending cancellationS/N 78-30898N2820BChildress Kenneth W · Longview, TXBuilt 2008 · S/N 31-0099N2820RHutter Karl G · Reno, NVBuilt 1967 · S/N 18258420N2821ALewton John E · Belgrade, MTBuilt 1953 · S/N 30021N2821K4608 Vista LLC · Fort Lauderdale, FLS/N 18053089N2821QHattan Richard A Trustee · Fairbanks, AKBuilt 1977 · S/N 18503533N2821RNielson David L Trustee · Anchorage, AKBuilt 1967 · S/N 18258421N2822MWendt Robert R · Sedona, AZBuilt 1953 · S/N 30010N2823AMckinney Eric S · Hamersville, OHS/N 30023N2824AStrode Lawrence W · Naknek, AKS/N 30024N2824MDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 1144N2824WBrown Logistics LLC · Auburn, WABuilt 2019 · S/N 1980N2825FStephens Jeffrey G · Gig Harbor, WABuilt 1966 · S/N 18256925N2825KHigh Flying Club Inc · Fort Wayne, INBuilt 1979 · S/N 28R-7931212N2825ROjeda Holdings LLC · Gainesville, GABuilt 1967 · S/N 18258425N2825XJames Ray Inc · Twin Falls, IDS/N P206-0025N2825YSalva Kenneth J · Shingle Springs, CABuilt 1962 · S/N 18253825N2826AConfer Gary R · Washougal, WABuilt 1953 · S/N 30026N2827NN714dd LLC · Pembroke Pines, FLBuilt 1979 · S/N 34-7970262N2827TRegan Keith M · Torrance, CABuilt 1965 · S/N CD-953N2828ALatham Cory D · Great Bend, KSS/N 30028N2828FSmiley Neil J Trustee · Lake Havasu City, AZBuilt 1966 · S/N 18256928N2828KStephens Mark Edwin Trustee · Morgan Hill, CABuilt 1979 · S/N 18053091N2828LInverted LLC · Las Vegas, NVS/N 34-7970266N2828YHooey Kevin M · Beaver Dams, NYBuilt 1962 · S/N 18253828N2829YN2829y LLC · Longmont, COFirst renewal noticeBuilt 1962 · S/N 18253829N282ATMoonraker Iixl LLC · Wilmington, DEBuilt 2019 · S/N 2025N282CBWhisky Tango LLC · Hendersonville, TNBuilt 2011 · S/N 3782N282CDAurora Partners LLC · Oregon City, ORBuilt 2004 · S/N 1136N282CPWright Andrew T · Clyde, OHBuilt 1958 · S/N 51546N282DJViva LLC · Dover, DEBuilt 2021 · S/N 5066
Back to AD 2000-23-21