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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2553TDavis David F · Oregon, ILBuilt 1974 · S/N 2553 N2554KBelleair Aviation LLC · Clearwater, FLS/N 18052985 N2554RBartlett Richard H · Sussex, NJBuilt 1967 · S/N 18258254 N2554SHanan Roy T · Edgewater, FLS/N 337-0854 N2554TAlvion LLC · Unionville, INBuilt 1975 · S/N NAV-4-2554 N2554XWallin Justin · Henderson, NVBuilt 1964 · S/N P206-0054 N2554ZClement L Ross · Anchorage, AKBuilt 1963 · S/N 185-0554 N2555TFrez Raymond · Jacksonville, FLBuilt 1975 · S/N NAV-4-2555 N2556QDuan Yutao · Walnut, CABuilt 1977 · S/N 28R-7703068 N2556XHusnik Brad M · Forest Lake, MNFirst renewal noticeBuilt 1964 · S/N P206-0056 N2557RWhite Willis W · Boise, IDBuilt 1967 · S/N 18258257 N2557TSouthwest Aircraft LLC · Fairacres, NMS/N NAV-4-2557 N2557XRegistration Pending · Troy, IDRegistration pendingBuilt 1964 · S/N P206-0057 N2558GScolari Shawn Fenton · Meeteetse, WYS/N 51858 N2558RKahn Steven P · Boise, IDBuilt 1967 · S/N 18258258 N2559JStuder Alfred C · Shelby, MIBuilt 1979 · S/N T18803482T N2559QJordan Valley Aviation LLC · Jordan Valley, ORBuilt 1966 · S/N 18257759 N2559XElement Building Solutions Inc · Murphys, CABuilt 1965 · S/N P2060059 N255AOld Aircraft Inc · Lake City, FLBuilt 1956 · S/N 35285 N255BABgp Realty Inc · Boca Raton, FLBuilt 1967 · S/N TE-364 N255BSScheeler Gerard M · Granbury, TXBuilt 2001 · S/N 0069 N255DDAlifarhani David · Vestavia, ALBuilt 2000 · S/N 1095 N255DPLandseadel Bradley Arnold · Gilbert, AZBuilt 2007 · S/N 2728 N255EM255em LLC · Tampa, FLBuilt 1973 · S/N TC-1552 N255FSSharpline Converting Inc · Wichita, KSBuilt 1980 · S/N TC-2306 N255JFEuroaria LLC · Newark, DEBuilt 2019 · S/N 2046 N255JPN255jp LLC · Little Rock, ARBuilt 2008 · S/N 3084 N255JWDillon William M · Dayton, NVBuilt 1987 · S/N 25-1117 N255KBailey Michael S · Sarasota, FLBuilt 1961 · S/N TC-74 N255KCLimitless Master Mind LLC · Cranberry Township, PABuilt 2023 · S/N 9286 N255MAKmco Inc · Lenexa, KSBuilt 1967 · S/N TE-318 N255MBPhoenix Aircraft Management LLC · Marathon, FLFirst renewal noticeBuilt 1968 · S/N 310N-0110 N255RWas Group LLC · Wilmington, DEBuilt 1973 · S/N TC-1518 N255SBCupertino Airlines LLC · Wahoo, NEBuilt 2017 · S/N 1566 N255SW255sw LLC · Highlands Ranch, COBuilt 2007 · S/N 2473 N255TLAviators LLC · Rehoboth, DEBuilt 2023 · S/N 9619 N255WPUnited States Air Force Owner · Hanscom Afb, MAFirst renewal noticeS/N TF-38 N255WTRedsky Capital Partners LLC · Coral Gables, FLBuilt 2021 · S/N 2411 N255XMS-Tee Corp · Mineri Wells, TXBuilt 1966 · S/N TE-263 N2560GJackson Air LLC · Temecula, CABuilt 1959 · S/N 51860 N2560XCd Hillcroft Aviation LLC · Superior, COBuilt 1965 · S/N P206-0060 N25612Mad Scientist Aviation LLC · Wilmington, DES/N TE-897 N25615Roark Co Inc · Montgomery, ALBuilt 1973 · S/N E-460 N2561QMariposa Aviation Inc · East Wenatchee, WABuilt 1966 · S/N 18257761 N2561RHeber Valley Flying Club · Park City, UTBuilt 1967 · S/N 18258261 N2561TBlumenstock Kenneth A · Culpeper, VABuilt 1976 · S/N NAV-4-2561 N2561XN343ga Leasing LLC · Anchorage, AKBuilt 1965 · S/N P206-0061 N25625Martinez Maurice Dominic · La Habra, CABuilt 1973 · S/N E-393 N25627Sutter Jacob O · Roland, ARBuilt 1973 · S/N TH-295 N2562DWalker Garrett J · Anchorage, AKBuilt 1952 · S/N 20714

Back to AD 2000-23-21