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.

N155THEs Aviation LLC · Memphis, TNBuilt 2006 · S/N 1965N155WCTca Equities LLC · Advance, NCBuilt 1981 · S/N TE-1193N155ZPennsylvania College Of Technology · Williamsport, PABuilt 1981 · S/N TJ-368N1560WHigh Performance Aircraft Inc · El Cajon, CABuilt 1997 · S/N E-3097N1560YPacific Integrated Handling · Tacoma, WABuilt 1994 · S/N TH-1717N1560ZYoung James Scott · Kemah, TXBuilt 1961 · S/N D-6863N1561BLamberton Dale F · Brush Prairie, WABuilt 1996 · S/N E-2993N1561CDoncat LLC · Shelby, MTS/N 30261N1561GDusky Aviation LLC · Atlanta, GABuilt 1994 · S/N E-2854N1561LRegistered aircraftBuilt 1994 · S/N E-2856N1561MWagner Lacy F · Mission Viejo, CABuilt 1989 · S/N CE-1374N1561TUmanzor Daniel A · S San Fran, CABuilt 1994 · S/N CE-1777N1561WEmpresas Marex Inc · Mayaguez, PRS/N TC-1445N1562BKaplan Steven H Trustee · Santa Barbara, CABuilt 1989 · S/N CE-1362N1562FPatton Janet · Denton, TXBuilt 1994 · S/N E-2857N1563BShulman David A · Frisco, TXBuilt 1994 · S/N CE-1776N1563EZulu Alpha LLC · Naperville, ILBuilt 1989 · S/N E-2473N1563FMcintyre Philip · Monterey, CABuilt 1994 · S/N CE-1782N1563RNovember One LLC · Trophy Club, TXS/N E-2858N1563SMiller Edward L · Santa Rosa, CABuilt 1962 · S/N CD-524N1563TN1563t LLC · Sheridan, WYS/N 414-0278N1563WArmstrong James L Trustee · Santa Barbara, CABuilt 1972 · S/N D-9370N1564AMcnutt Seth D · Paoli, INBuilt 1989 · S/N CE-1321N1564CGeisert Carl E · Chandler, AZBuilt 1953 · S/N 30264N1564DAwy LLC · Bentonville, ARBuilt 1994 · S/N E2905N1564LWhipple Cory · Senatobia, MSBuilt 1976 · S/N TK-6N1564RKm Unlimited LLC · Fallbrook, CABuilt 1988 · S/N EA-487N1564SRegistered aircraftBuilt 1962 · S/N TC-313N1565CGarrett Carter L · Soldotna, AKS/N 30265N1565MSwiss Horizon Family Inc Trustee · Wilmington, DEBuilt 1958 · S/N 50160N1565SAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2007 · S/N 41761N1565TForbes Consolidated Inc · New Smyrna Beach, FLBuilt 1974 · S/N 310R0063N1565WRoad Kill Aviation Inc · Wilmington, DEBuilt 1972 · S/N E-330N1565XCutting Paul P · Wellington, FLBuilt 1994 · S/N E-2853N1565ZStowe Martin D · Carlsbad, CABuilt 1961 · S/N D-6867N1566FSelhay Michael J · Anchorage, AKBuilt 1965 · S/N 185-0943N1566GDuntz David W · Beavercreek, OHBuilt 1989 · S/N CE-1346N1566KShaw David C · Santa Barbara, CABuilt 1989 · S/N TH-1549N1566LRedden Timothy Ray · Citrus Heights, CABuilt 1976 · S/N D-9862N1566PBeech Powers LLC · Henderson, NVBuilt 1988 · S/N CE-1294N1566URegistered aircraftBuilt 1994 · S/N E-2872N1566WPsl Aviation Inc · Atlanta, GABuilt 1994 · S/N TH-1713N1567AKarsten Steven R · San Juan Capo, CABuilt 1969 · S/N TC-1270N1567MPlumbo John T · Port Saint Lucie, FLBuilt 1989 · S/N CE-1407N1567NAuburn Simflight LLC · Auburn, ALBuilt 1989 · S/N TH-1567N1567PMy Family Holdings LLC · Greenwood, SCBuilt 1988 · S/N CE-1296N1567SWegener Properties LLC Series Bonanza · Aurora, ILBuilt 1962 · S/N D-6993N15688Moses & Associates Inc · Gainesville, FLBuilt 1988 · S/N TH-1542N1568ZKeenan Michael Richard Sr · Albuquerque, NMBuilt 1961 · S/N D-6870N1569LRegistered aircraftBuilt 1976 · S/N TC-1945
Back to AD 2000-23-21