OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N3498SEnz Vineyards Inc · Hollister, CABuilt 1964 · S/N 18255898N3498UVintage Flyers LLC · Easton, PABuilt 1963 · S/N 18254898N3499SSky'S Mooney LLC · Missoula, MTBuilt 1964 · S/N 18255899N349BPLundeen Matthew L · Tigard, ORBuilt 2008 · S/N 29-0508N349CDRabdau Brandan Joseph · Land O Lakes, FLBuilt 2005 · S/N 1509N349RFPhase 2 Ventures LLC · Seattle, WABuilt 2003 · S/N ES-102-FBN349RPMiranda Gary R · Vancouver, WABuilt 1998 · S/N E-3202N349YVam Aviation LLC · Edmond, OKBuilt 1962 · S/N TC-389N34ADPremiere Aviation Inc · Concord, CABuilt 1975 · S/N 421C-0036N34AFHangar 6 Aviation LLC · Destin, FLBuilt 1954 · S/N 34-51N34AHElastapro Silicone Sheeting LLC · Santa Fe Springs, CABuilt 2024 · S/N 9783N34ALVy Strategies LLC · Dublin, GABuilt 2017 · S/N 1516N34ANScala Peter M · Port Orange, FLBuilt 1954 · S/N CG-4N34AQZimmerman Steven W · Olathe, KSBuilt 1956 · S/N CG112N34ATField Kent · Santa Barbara, CABuilt 1957 · S/N G-139N34AWValiair Lc Trustee · Casper, WYBuilt 1976 · S/N 340A0097N34AXPw58 LLC · Dover, DEBuilt 1956 · S/N CG-141N34BMaresco International Corp · Alpha, NJBuilt 1952 · S/N G-17N34BAPrvny Pluk LLC · Houston, TXBuilt 1956 · S/N G-797N34BBMcvay Larry A · Boise, IDS/N 33725N34BFSam Aviation LLC · Elberton, GABuilt 1975 · S/N 34-7670029N34BPAviation Insurance Managers Inc · Uniontown, OHBuilt 2014 · S/N TH-2420N34BQBettendorf Nicholas L · Mchenry, ILBuilt 1957 · S/N 144025N34BRIndustrial Reports Inc · Raleigh, NCBuilt 1981 · S/N CE-946N34BTWilliams Charles R · Wadsworth, OHBuilt 1973 · S/N 21060130N34BVDessuit Franklin Jr · Mckinney, TXBuilt 1956 · S/N CG-152N34BWMaintenance Forecasters Inc · Falmouth, MIBuilt 1974 · S/N TC-1691N34BZDimich Milan C · Madison, SDBuilt 1958 · S/N CG-209N34CDCannon David A · Magnolia, TXBuilt 2002 · S/N 0148N34CFPayne James Michael · Twin Falls, IDBuilt 1974 · S/N 18052473N34CKJaycox Chad Trustee · Venice, FLBuilt 2023 · S/N 9144N34CQRocky Mountain Warbirds LLC · Kalispell, MTBuilt 1958 · S/N CG-217N34CRRounds Donald C DBA · Waller, TXS/N G-758N34CURegistered aircraftBuilt 1958 · S/N CG-218N34CWRegistered aircraftBuilt 2018 · S/N 1170N34CXSchwerman Carl J · Oconomowoc, WIS/N CG-223N34DBRegistered aircraftBuilt 2003 · S/N 29-0300N34DKTennessee Aviation Services LLC · Sevierville, TNBuilt 1962 · S/N G-744N34DMGlotfelty John E · Durango, COBuilt 1959 · S/N 52329N34DSMachado Rocha Conrado · Aventura, FLBuilt 1984 · S/N 28R-8431019N34DTSutton William E · Salinas, CABuilt 1953 · S/N G-114N34DYMccormick Daniel · Salem, SCBuilt 1956 · S/N G-730N34ECGerard Aircraft Inc · Battle Creek, MIBuilt 1975 · S/N P3370224N34EHWisconsin Aviation Inc · Watertown, WIBuilt 1993 · S/N 3448031N34EMSpirit Rotorcraft LLC · Phoenix, AZBuilt 1955 · S/N 53-4150N34EVSilva Alexander J · Holly Springs, NCS/N G-16N34FFZwierlein Victor · Grand Prairie, TXBuilt 1976 · S/N U20603334N34FHJeffcoat Jon T · Nome, TXBuilt 1981 · S/N E-1836N34FRFront Runner Capital LLC · Newark, DEBuilt 2024 · S/N 9945N34FUWatson George E · Temecula, CABuilt 1956 · S/N BG-180
Back to AD 2000-23-21