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.

N321MMJohnson Curtis A · St Paul, MNBuilt 1979 · S/N 18503976N321MTIflyhi Aviation LLC · Sanbornton, NHBuilt 2005 · S/N 1696N321NOatman Scott A · Colorado Springs, COBuilt 1968 · S/N TE-583N321PGN321pg Corp Trustee · Wilmington, DEBuilt 2010 · S/N 0037N321PMPilotpros Training LLC · Longview, TXBuilt 2011 · S/N 3827N321PPMathews Aviation LLC · Marysville, CABuilt 1977 · S/N 18265834N321QCAden Michael L · Maryville, ILBuilt 1980 · S/N 25-0353N321RBMessmore Micheal Henry · Toledo, WABuilt 1976 · S/N 18052677N321RHTorrey Daniel B · Ojai, CAS/N 74-30657N321RKGaston Charles · Stephens, ARBuilt 1979 · S/N 25-0108N321RMBigler & Associates Aviation Inc · Cameron Park, CABuilt 1979 · S/N 25-0230N321RPIsrael Oscar M III · Sinton, TXBuilt 1973 · S/N 340-0201N321RR321 Rr Lp · Wimberley, TXBuilt 1968 · S/N TE-520N321SETesla Aviation LLC · Mount Pleasant, SCBuilt 2006 · S/N 2089N321SLSchlachter Drue · Fall River, WIBuilt 2016 · S/N 2325N321TBMob Aviation USA LLC · Auburndale, FLBuilt 1982 · S/N E-1998N321TFStarhawk LLC · Denver, COBuilt 2015 · S/N L2K-173N321TSSelby Arrie Trustee · Equality, ALBuilt 2013 · S/N 0481N321TTN321bluesky LLC · Sugar Land, TXBuilt 2020 · S/N 2228N321VPOn Centerline Aviation LLC · Denver, COBuilt 2025 · S/N 91402N321WValiair Limited Company Trustee · Ogden, UTBuilt 2006 · S/N 1727N321WDWhiskey Delta Holdings LLC · Collinsville, TXBuilt 2021 · S/N 2353N321WHBonanza Equipment Leasing LLC · Missoula, MTBuilt 1979 · S/N 18266927N321WMMartinez Jose A · Orlando, FLBuilt 1975 · S/N TH-571N321WPRadmall LLC · Commerce City, COBuilt 1995 · S/N E-2929N321WRFord Paul · Princeton, NJBuilt 2002 · S/N 0269N321WVHill Stephen D · Lincoln, NEBuilt 2012 · S/N TH-2343N321WYWhitescarver Suzanne L Trustee · Las Vegas, NVBuilt 2016 · S/N L2K-273N321XVerrall Charles Peter Jr · Florence, AZS/N D-5990N3220JFagen Inc · Granite Falls, MNBuilt 1995 · S/N E-2920N3220YTanner Fred E · Westville, FLS/N 18254327N3221SPropwash LLC · Mesquite, NVBuilt 1964 · S/N 18255721N3221YRegistration Pending · Brea, CARegistration pendingS/N 18254221N3222DBeggs Patrick C · Salem, ORBuilt 1955 · S/N 32020N3222PAmlz Air LLC · Rockville, MDBuilt 1995 · S/N EA-573N3222UMilpower Inc · Nampa, IDBuilt 1995 · S/N E-2919N3222YCreighton Andrew M · Lebanon, TNBuilt 1962 · S/N 18254222N3223BTechmur LLC · Loudonville, NYBuilt 1995 · S/N E-2923N3223DCliff Robinson Real Estate Corp · Madison, INBuilt 1955 · S/N 32021N3223UPerry Joseph R · Portland, ORBuilt 1963 · S/N 18254623N3224QRech Jack R · Mohave Valley, AZBuilt 1999 · S/N E3224N3224SSkylane Trio Ltd · La Junta, COBuilt 1964 · S/N 18255724N3224YCrouchet Jay · Kremlin, MTBuilt 1962 · S/N 18254224N3225KWjm Aviation LLC · Friendswood, TXBuilt 1995 · S/N E-2975N3225UBlizzard Air LLC · Midland, TXBuilt 1963 · S/N 18254625N3225YSamaritans Purse · Boone, NCS/N 18254225N3226BSooner Aviation LLC · Norman, OKBuilt 1999 · S/N E3226N3226JSimms Matthew · Davie, FLBuilt 1994 · S/N E-2855N3226QDenning Aviation Inc · Fort Madison, IABuilt 2000 · S/N E-3326N3226SJones David A · Wasilla, AKBuilt 1964 · S/N 18255726
Back to AD 2000-23-21