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.

N189CRPelco Investments Inc · Wilmington, DEBuilt 1981 · S/N TE-1187N189FTeag Leasing LLC · Edmonds, WABuilt 2001 · S/N EA-680N189FA243 Kts LLC · Wilmington, DEBuilt 2008 · S/N 31-0089N189FGAerotech Coatings LLC · Arlington, WABuilt 2016 · S/N 4378N189JAPapillon Airways Inc · Kirkland, WABuilt 1969 · S/N 18259569N189LESwt Aviation Inc · Newport Beach, CABuilt 2011 · S/N E-3957N189MWindh Steven R · Reedley, CABuilt 1963 · S/N 283N189MCThree Thirty Three LLC · Wilmington, DEBuilt 2010 · S/N 0045N189MKS2ar Aviations LLC · Lantana, FLBuilt 1978 · S/N 414A0100N189MLStrobe Aviation LLC · Columbia, SCBuilt 1977 · S/N 34-7770114N189PGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 1896N189PWArrivee LLC · Manhattan Beach, CABuilt 2019 · S/N 1964N189SElfdog Aviation LLC · New Franken, WIBuilt 1960 · S/N 52778N189STSierra Tango Aviation LLC · Colleyville, TXBuilt 2026 · S/N 11452N189WHBonafide Investments LLC · Dover, DEBuilt 1969 · S/N 18052059N18AWayman Ian A · Medford, ORS/N CE-629N18ADEzs Flyers LLC · Bonduel, WIBuilt 1972 · S/N 18261116N18ARBas Part Sales LLC · Greeley, COBuilt 1965 · S/N CD-959N18AS1607 Vistas LLC · Fort Lauderdale, FLBuilt 2023 · S/N 9059N18AVAdvanced Aviation LLC · Merrick, NYBuilt 2018 · S/N 4729N18BBMuseum Of Flight Foundation · Seattle, WAFirst renewal noticeBuilt 1967 · S/N 337M0069N18BCT-Air LLC · Schofield, WIBuilt 2024 · S/N 10119N18BEStarkey Thomas David · Nashville, TNBuilt 1977 · S/N CE-726N18BGTommervik Sean · Philadelphia, PAS/N 02GN18BKShandog Air LLC · Ashland, KYS/N 310R0981N18CDDorman Richard E · Mesa, WABuilt 1964 · S/N 18051402N18CKHatch Aviation LLC · New Braunfels, TXBuilt 2017 · S/N 1581N18CLAkro Attitudes Inc · Boynton Beach, FLS/N 52838N18CNTab Flyers LLC · Champaign, ILBuilt 1968 · S/N CE-208N18CYBraylin Air LLC · Jupiter, FLBuilt 2018 · S/N 1740N18DADye Paul C · Mcneal, AZBuilt 1977 · S/N 18503439N18DLBelov Mikhail · Greenwood Village, COBuilt 1977 · S/N 310R1251N18DMRachal Randolph B · Taft, TXBuilt 1969 · S/N 18259374N18DNZba LLC · Hurricane, UTBuilt 2001 · S/N 0096N18DRBurns Donald N DBA · Watkinsville, GABuilt 1978 · S/N E1228N18EFWade William G · Unity, MEBuilt 1954 · S/N 154 192N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394N18EJPelizzon David R Trustee · Naples, FLBuilt 2007 · S/N E-3803N18EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11416N18EWCahill Thomas · Queensbury, NYBuilt 1966 · S/N CE-22N18GGLogan Rob · Watervliet, NYBuilt 2002 · S/N 134N18GKJackson Air LLC · Duluth, MNBuilt 2013 · S/N 2225N18GWMcbride Kenneth B · San Martin, CABuilt 1949 · S/N 35N18HBBuermann Henry · Brookfield, VTS/N 30912N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651N18JHGarnet Aerospace LLC · Windsor, COBuilt 1963 · S/N TC-495N18JLKlapmeier Alan · Iron River, WIBuilt 1974 · S/N P337-0165N18KFNelco Inc · Blanchard, OKBuilt 1978 · S/N E-1251N18LLPiping Technology Consultants Inc · Monee, ILBuilt 1978 · S/N E-1332N18MDN18md Aviation LLC · Salem, ORBuilt 1967 · S/N TE-455
Back to AD 2000-23-21