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.

N1882ZConstable William H · Rch Palos Vrd, CABuilt 1962 · S/N 205-0082N1883FAnkeney Scott · Canyon, TXBuilt 1966 · S/N 21058783N1884XKaines John L · Ludington, MIBuilt 1965 · S/N 18255984N1885MLittle Dog Aviation LLC · Anchorage, AKBuilt 1975 · S/N 18264468N1885WS35s LLC · Stevens Point, WIBuilt 1973 · S/N D-9485N1886HGoodwin Joseph N · Grass Valley, CABuilt 1959 · S/N 35986N1886W86 Whiskey Corporation · Vineland, NJBuilt 1973 · S/N E-441N1887FHeadings Kevin · Echo, ORS/N 21058787N1887ZDavidson David R · Sutton, AKS/N 205-0087N1889FPiper Henry Burton Jr · Kingston, TNBuilt 1966 · S/N 21058789N1889WSabre 65 LLC · Helena, MTBuilt 1973 · S/N TH-341N188AJA&J Specialties LLC · Hickory, PABuilt 2025 · S/N 10762N188JRNwga Aero Farms LLC · Dalton, GABuilt 2015 · S/N 2298N188LSJms Small Aircraft Fl LLC · Aventura, FLBuilt 2022 · S/N 8933N188MAAviation Leasing LLC · Erie, COBuilt 2008 · S/N 3096N188MGMarkusair Leasing LLC · Wilmington, DEBuilt 2018 · S/N 32-0006N188MHAndree'S Avion LLC · Santa Fe, NMBuilt 2013 · S/N 0499N188RCHodgskies Holdings LLC · Choteau, MTBuilt 1984 · S/N E-2189N188RJWilliams Debbie C · Riverside, CABuilt 1963 · S/N D-7205N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636N188VMaximus Aviation LLC · Cheyenne, WYBuilt 1955 · S/N 101N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67N188YMbaa Holding LLC · Myrtle Beach, SCBuilt 1964 · S/N TC-790N189Jones William Cody · Roxton, TXS/N P3370209N1890MPutney Bruce N · Midlothian, TXS/N 33701490N1890ZAlaniz Jose M · Yreka, CABuilt 1962 · S/N 205-0090N18916Valiair Lc Trustee · Casper, WYBuilt 2006 · S/N 2075N1891DDale Richard C · La Vernia, TXS/N D-3163N1891MStarkman Timothy S · Monterey, CABuilt 1975 · S/N 18264470N1891WSchwartz Eric · Timnath, COBuilt 1973 · S/N E-440N1892FPanagotacos George · Corona, CABuilt 1966 · S/N 21058792N1892LMcnair Craig · Dayton, TXBuilt 1976 · S/N D-9897N1892XCuvar Philip M · Granite City, ILBuilt 1965 · S/N 18255992N1893FKleeman Mark · Kearney, MOFirst renewal noticeS/N 21058793N1893LHarlan Blake · Trinity Center, CABuilt 1976 · S/N E-863N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662N1894XCorso Aviation LLC · Southlake, TXBuilt 1964 · S/N 18255994N1894ZEverly Peter · Fort Smith, ARBuilt 1962 · S/N 205-0094N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16N1896SSky Dds LLC · Las Vegas, NVBuilt 1998 · S/N 3449088N1896XSmr Holdings LLC · Martinsburg, WVBuilt 1964 · S/N 18255996N1897EThompson Loren Charles · Arlington, VABuilt 1966 · S/N D-8313N1897LHrt Aviation LLC · Southlake, TXBuilt 1976 · S/N TC-1971N1898ZSmart Robbie A · Wasilla, AKBuilt 1962 · S/N 205-0098N18998Duffer Management LLC · Carlsbad, CABuilt 1977 · S/N D-10073N1899MLoki Adventures LLC · Norwood, COBuilt 1975 · S/N 18264472N1899ZLarlee Coleman R · Millbrook, ALBuilt 1962 · S/N 2050099N189AAJungclaus Karl F · Piedmont, SDBuilt 1959 · S/N D-6024N189CFRascher Lawrence · Pacific, MOS/N 18255465
Back to AD 2000-23-21