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.

N2DURegistered aircraftBuilt 1977 · S/N D-10030N2EBCampbell Bernard D · Morehouse, MOBuilt 1971 · S/N 18260609N2ESBuilding Solutions LLC · West Palm Beach, FLBuilt 2006 · S/N 41672N2EYBender Jeffrey T · Scottsdale, AZBuilt 1967 · S/N D-8401N2FKAshwath Nagaraj · Los Altos Hills, CABuilt 1978 · S/N CE-834N2FRMarcum Alan M · Palo Alto, CABuilt 1989 · S/N 25-1211N2FTContemporary Aviation LLC · Excelsior, MNBuilt 2024 · S/N 10307N2GAWilson Frank C · Irondale, OHBuilt 1974 · S/N 18502376N2GHAbel Robert G · Williamstown, MABuilt 1963 · S/N 2050369N2GRRichardson Gordon B II · Caldwell, TXBuilt 1961 · S/N D-6659N2HNFlyboy Aviation LLC · Pensacola, FLBuilt 2020 · S/N 052N2HSIsland Pearl Airways · Doral, FLFirst renewal noticeBuilt 1979 · S/N 34-8070022N2JJAerial Surveys International LLC · Watkins, COBuilt 1968 · S/N 401-0235N2JKGoldberg Leonard J · Westbrook, CTBuilt 1977 · S/N 18265546N2JXBrookeash Inc · Waxahachie, TXBuilt 1965 · S/N D-7811N2KBKb Aviation LLC · Mission Viejo, CABuilt 1974 · S/N E-599N2KMBas Part Sales LLC · Greeley, COBuilt 1973 · S/N TC-1608N2LCStults Curt M · Choctaw, OKBuilt 1961 · S/N CD-403N2LHStotlar Richard L · Tucson, AZBuilt 1987 · S/N CE-1133N2LSNiec Steven M · Clio, MIBuilt 1975 · S/N 3N2MAFlorida Air Leasing LLC · Gainesville, FLBuilt 2004 · S/N 1177N2MBAlfa Foxtrot LLC · Statesville, NCBuilt 1978 · S/N 310R1357N2MLMclaury Kim · Mission Hill, SDBuilt 1997 · S/N E-3114N2MTO'Leary John M · Fresno, CABuilt 1963 · S/N CD-612N2MUGarrison Peter · Los Angeles, CABuilt 2002 · S/N 1N2PJMorgan Bryan K · Sacramento, CABuilt 1969 · S/N 337-1161N2QFAbel Elliot A · Terre Haute, INBuilt 1977 · S/N P3370280N2QMNorth Casade Air Transport LLC · Manson, WABuilt 1977 · S/N P3370290N2QPNoess Michael A · Shakopee, MNBuilt 1977 · S/N P3370291N2REEtzler Richard D · Durango, COBuilt 1997 · S/N 185N2RXJbs Enterprises LLC · Hamilton, MTS/N P21000030N2SAInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 29-0376N2SLLowe Aviation LLC · Bountiful, UTBuilt 1977 · S/N 21061908N2TGB2c2 Aviation LLC · Piedmont, CABuilt 1969 · S/N 337-1064N2UGBaker Gregory L · Hilton Head Island, SCBuilt 1988 · S/N CE-1267N2UMHepfer John Edward · Midland, TXBuilt 1958 · S/N 35649N2UNSuriel Darleny G · New York, NYBuilt 1969 · S/N 28R-31080N2UTDemaeyer Thomas A · Fort Lauderdale, FLBuilt 1969 · S/N TC-1203N2VRRead Andrew R · Milwaukee, WIBuilt 1980 · S/N EA-62N2VVAir Mods And Repair Inc · Robbinsville, NJBuilt 1976 · S/N TK-37N2VYSmith William E Jr · Havre De Grace, MDBuilt 1955 · S/N BG-67N2WSeldom Seen Aviation Northwest Inc · Stevensville, MTS/N 185-02982N2WDBrantley Scott R · Great Bend, KSBuilt 1950 · S/N NAV-4-2153-BN2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEBuilt 1975 · S/N U20602849N2WLAlces Aircraft LLC · Wilmington, DEBuilt 1990 · S/N 112N2WTJohnson Michael A · Winter Park, COS/N 38117N2XFN2xf LLC · Windermere, FLBuilt 2008 · S/N 3RX029N2XNDudebuddy Aviation LLC · Kalispell, MTBuilt 1980 · S/N 18267615N2XSCarter Delton W · Montgomery, TXBuilt 1988 · S/N 88-301000N2XXTyler James · Oklahoma City, OKS/N 310L0182
Back to AD 2000-23-21