OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,142

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.

N1224NAviation Insights LLC · Chester Springs, PABuilt 2024 · S/N 10308N12250Renforth Michael · Yorktown, VABuilt 1955 · S/N G-701N12252Maresco International Corp · Alpha, NJBuilt 1965 · S/N G-704N12253Breitenstine Matthew · Dallas, TXS/N G-705N12255Cirrus Management LLC · Suwanee, GAS/N G-707N12258Bacon Otis Blake · Fremont, CABuilt 1955 · S/N G-722N1225MMarlin Roger · Morgan Hill, CABuilt 1971 · S/N 33701425N1225PRegistered aircraftBuilt 2006 · S/N 2257N1225QDupont Larry W · North Hero, VTBuilt 1977 · S/N 18503472N1225ZFree Gregory · Monroe, IABuilt 1961 · S/N D-6692N12264Enk William A Sr Trustee · Blue Springs, MOBuilt 1956 · S/N G-818N12275Bachman Mildred R · New Brighton, PABuilt 1965 · S/N G-263N1227FPeterson Investments Inc · Polson, MTBuilt 1975 · S/N 18502789N1227WErlich Austin · Los Angeles, CABuilt 2017 · S/N 1522N1228Hodges Farms LLC · Grain Valley, MOBuilt 1987 · S/N 4608092N12281Flippen John P · Bonita, CABuilt 1955 · S/N G-293N1228ERag Experimental LLC · Klamath Falls, ORBuilt 1998 · S/N LIV190N1228GMcdaniel Dean K · Mesa, AZBuilt 1974 · S/N 310Q1081N1228MHillsboro Flying Club · Hillsboro, ORBuilt 1975 · S/N 18264247N1228PPapa Aviation LLC · Chicago, ILBuilt 1990 · S/N E-2577N1228ZPate Ronald E · Hilltop Lakes, TXBuilt 1961 · S/N D-6688N1229VSale Reported · Greeley, COSale reportedBuilt 2008 · S/N 411110N122AJPalo Alto Aviators Inc · Menlo Park, CABuilt 2005 · S/N 1547N122AMHarper David · New Richmond, WIBuilt 1973 · S/N 310Q0943N122ARN122ar LLC · Laredo, TXBuilt 2019 · S/N 4838N122ASAviator Services Inc · Miami, FLBuilt 2009 · S/N 3391N122BMZikita Management LLC · Los Altos, CABuilt 2017 · S/N 4459N122CDYvie Air LLC · Newburgh, NYBuilt 2025 · S/N 10860N122CERay Kevin T · Columbus, TXBuilt 1979 · S/N E-1475N122CGHollywood Aviation Investments LLC · Hollywood, SCBuilt 2001 · S/N 0098N122CLProset Aviation LLC · Montrose, COBuilt 2006 · S/N 2108N122CTTurner Eye Clinic Inc · Cabot, ARBuilt 1976 · S/N TE-1070N122CVDonnellan William B · Chattanooga, TNBuilt 2003 · S/N 0450N122DRCirrus Sr22t 1824 Inc Trustee · Wilmington, DEBuilt 2018 · S/N 1824N122DZFitzpatrick Nolan · Urbandale, IABuilt 2004 · S/N 1465N122EOne Two Two Echo Aviation LLC · Cincinnati, OHBuilt 1973 · S/N 310Q0984N122ECBronte LLC · Boise, IDBuilt 2024 · S/N 10267N122EEAir-Burt LLC · Rochester Hills, MIBuilt 2013 · S/N TH-2382N122EPN122ep LLC · Coushatta, LABuilt 2014 · S/N 4138N122ESCooper Anthony · Bainbridge, GABuilt 2015 · S/N 4188N122FSiver Creek Capital LLC · Emery, SDS/N 21058967N122FAFox Alpha LLC · Londonderry, NHBuilt 2004 · S/N 1452N122GWhittier Roger A · Glendale, AZBuilt 2001 · S/N 0009N122GHThompson Jason · River Heights, UTBuilt 2002 · S/N 0175N122HBBych Robert Peter Trustee · Chandler, AZS/N 1762N122HDDadwal Aviation LLC · Seaside, CABuilt 2020 · S/N 4921N122JHValentine Terence S · Glennallen, AKBuilt 1966 · S/N R-172-0086N122JKBenhaven Aviation LLC · Red Lodge, MTBuilt 2013 · S/N 0473N122JRSisto Donato · Rye, NHBuilt 2023 · S/N 9060N122JSGraham Design Services Inc · Dawsonville, GABuilt 1979 · S/N 18266866
Back to AD 2000-23-21