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.

N3185CThree Pipers Piping LLC · Charleston, SCBuilt 2000 · S/N E-3324N3185DMorgan Douglas C · Anchorage, AKBuilt 1955 · S/N 31983N3185F85 Foxtrot LLC · Redmond, ORS/N 18257285N3185QPara Tactics LLC · Shelton, WABuilt 1967 · S/N 18258185N3185YGochenour Air Inc · Fort Wayne, INBuilt 1962 · S/N 18254185N3186DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 31984N3186QKimbril Steve · Hartselle, ALBuilt 1967 · S/N 18258186N3186RHuey Gale R · Celeste, TXBuilt 1967 · S/N 18258586N3186YJram Air Parts LLC · Henderson, NVBuilt 1962 · S/N 18254186N31870Flight Level Aviators LLC · Glendale, AZBuilt 1978 · S/N 28R-7803302N3187CHemm Colby L · Newcastle, CABuilt 1954 · S/N 30986N3187FVolatile Aero Ventures LLC · Boulder City, NVBuilt 1966 · S/N 18257287N3187UMillikan Kimball S · Honolulu, HIBuilt 1963 · S/N 18254587N3187WG S Aviation Inc · Stilwell, KSBuilt 1974 · S/N TH-428N3187YMiller Richard G · Anson, TXS/N 18254187N3188QLutz Paul A Trustee · Seville, OHBuilt 1967 · S/N 18258188N3188SCrossman Charles · Rusk, TXBuilt 1964 · S/N 18255688N3188UAsb Avionics LLC · Mojave, CABuilt 1963 · S/N 18254588N3188YIngram Patrick Joseph · Pinedale, WYS/N 18254188N3189CSmith David J · Duluth, MNBuilt 1954 · S/N 30988N3189MSnowbird Aviation Corp · Signal Mountain, TNBuilt 2000 · S/N E-3325N3189SMarvin Franz Interests Inc · Victoria, TXS/N 18255689N3189ULaney Donald R · Inkster, MIS/N 18254589N3189YSkotynsky Michael · Broomfield, COBuilt 2001 · S/N E-3389N318ALeaders Robert O · Clear Lake, MNBuilt 1966 · S/N TE-229N318AT133g LLC · La Grange, ILBuilt 2018 · S/N 1783N318BHN318bh LLC · Wilmington, DEBuilt 2025 · S/N 10602N318BXLongshore Aviation LLC · Hyannis, MABuilt 2012 · S/N 3833N318CAKornegay Patrick · Harlingen, TXBuilt 2001 · S/N TH-2001N318CCVan Schoonhoven Nicholas R · Kent, WABuilt 1966 · S/N 18257289N318CPValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 3239N318CSTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N T24002097N318DSchutes John T · Brimfield, MABuilt 1967 · S/N TE-311N318DAJbid LLC · Delray Beach, FLBuilt 2018 · S/N 1669N318DESeries N318de Delta Echo Aviation Series LLC · Shavano Park, TXBuilt 2013 · S/N 2237N318DMDelta Kilo Mike LLC · Rayville, LABuilt 1977 · S/N 18266215N318EFLima Yankee Aviation LLC · Greenbriar, TNBuilt 2023 · S/N 9267N318EMCartel Drilling LLC · Wellington, COBuilt 2019 · S/N 1960N318FDWilliston Morrison Investment Partners LLC · Newark, DEBuilt 2021 · S/N 5101N318GAero Fliers Inc · Akron, OHBuilt 1966 · S/N CE-71N318MR318mr LLC · Missoula, MTBuilt 2006 · S/N 2026N318NRNorthern Arizona Investment Group LLC · Prescott, AZBuilt 1982 · S/N 18504382N318P318papa LLC · Calhoun, GABuilt 2015 · S/N ES-097N318RBBarker Angela · Skidmore, TXS/N 318N318SEVipr.Ai Leasing LLC · Exton, PABuilt 2019 · S/N 2000N318SVColorado Mountain Rv LLC · Fort Collins, COBuilt 2007 · S/N 2397N318UTraffic Law LLC · Tampa, FLBuilt 1977 · S/N 310R0994N318WBSkysurfer LLC · Reston, VABuilt 2023 · S/N 9378N318WTThompson Brent D · Bloomington, INBuilt 2003 · S/N 0474N318XTriple F Flying Inc · Benton, PABuilt 1975 · S/N 6145C
Back to AD 2000-23-21