OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N418MBRed Baron LLC · Dickinson, NDBuilt 1977 · S/N 18266154N418MLLloyd Morty C · Apison, TNBuilt 2006 · S/N 1781N418MWG2010 LLC · Greenwood Village, COBuilt 2025 · S/N 10418N418PCHajdu Paul R · Valley Center, KSBuilt 1971 · S/N 185-01843N418RMWind Sock Aviation LLC · Lancaster, KYBuilt 2005 · S/N 1719N418RWPower Aero Inc · Scituate, RIBuilt 1978 · S/N TH-917N418SASummit Aviation Inc · Middletown, DEBuilt 1979 · S/N 18267433N418TRAir Sunrise LLC · Mountain View, CABuilt 1982 · S/N 340A1525N4191SNiblett Brian E · Mount Pleasant, TXBuilt 1975 · S/N TC-1867N4192ARocky Mountain Aviation Inc · Wilmington, DEBuilt 1970 · S/N D-9128N4192SStecklein Aviation LLC · Colleyville, TXBuilt 1975 · S/N D-9766N4194QJacques Jerry J · Iliamna, AKS/N U2061359N4194SKilpatrick Bryan J · Poway, CABuilt 1975 · S/N E-677N4194WNicholson Jon S · Bethel, AKBuilt 1967 · S/N 1851203N4197CAll In Aviation LLC · Townville, SCS/N 414-0513N4197KRichardson Walter J Jr · Aliceville, ALBuilt 1947 · S/N NAV-4-1197N4197SIndependence Aviation Inc · Scottsdale, AZBuilt 1975 · S/N D-9762N4198GWindecker Aircraft Inc · Mooresville, NCBuilt 1970 · S/N 007N41990R H K Of Kansas Inc · Overland Park, KSBuilt 1945 · S/N 1421N419BBWinson Courtenay E · Tiki Island, TXBuilt 2012 · S/N L2K-109N419BEVolar La Vida LLC · Kalispell, MTBuilt 1968 · S/N 18259409N419CDRsk Aviation LLC · Midland, MIBuilt 2005 · S/N 1377N419HCZangs William J · Poplar Grove, ILBuilt 1978 · S/N 34-7870376N419KDDaniel Aviation LLC · Graniteville, SCBuilt 2020 · S/N 2225N419KSClear Blue Aviation LLC · Hayden, IDBuilt 1978 · S/N 0080N419SRN419sr Inc · Big Pine Key, FLBuilt 2006 · S/N 1650N419STMyers Steven L · Goodyear, AZBuilt 2005 · S/N 1656N419TN419t LLC · Boise, IDBuilt 1961 · S/N CD-323N419TFLee General Management LLC · Olive Hill, KYBuilt 2006 · S/N E-3742N419TRAmundsen John D · Soldotna, AKBuilt 1961 · S/N CD-411N419VTThomas Builders Inc · Niota, TNBuilt 2016 · S/N 1408N419WMGalf Aviation LLC · Thousand Oaks, CABuilt 2017 · S/N 1645N41ARobertson Roy E · Marion, IABuilt 1978 · S/N 21062798N41ANCampbell Ian · Miami, FLBuilt 2023 · S/N E-4153N41ARAdeline Air LLC · Scottsdale, AZBuilt 2024 · S/N 9835N41AYHunterdon Aviation Inc · Ringoes, NJBuilt 1978 · S/N 310R1416N41AZAlexander Peter · Palo Alto, CABuilt 1991 · S/N E-2628N41BXWilliams Paul E · Kendallville, INBuilt 1981 · S/N 18053197N41CASale Reported · Trapper C Reek, AKSale reportedBuilt 2017 · S/N 4559N41CEWhats Up Doc Aviation LLC · Alexander, ARBuilt 1978 · S/N 21062872N41CHLaperle Brian D · Colebrook, NHBuilt 1956 · S/N 32319N41DCDc Aircraft LLC · Shreveport, LABuilt 1953 · S/N G-106N41DKCirrus Sr22t 11533 Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11533N41DNNevels Donald L · Everton, MOBuilt 1984 · S/N DLN01N41DWOne Delta Whiskey LLC · Westport, CTBuilt 2024 · S/N 9802N41ECTreeline Helicopters Inc · Bristol, TNS/N TH-471N41EGSal Aviation Inc · Wilmington, DEBuilt 1978 · S/N TK-75N41EJDutta Sandeep · Foster City, CABuilt 1980 · S/N 25-0499N41FGHousley William M · Jasper, ALBuilt 1966 · S/N R1720093N41FROplnet LLC · Arlington, VABuilt 1972 · S/N E-371
Back to AD 2000-23-21