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.

N247ALOrtho Aviation LLC · Midland, TXBuilt 2022 · S/N 8821N247ASA & S Aviation Services Llp · EsherBuilt 2024 · S/N 10005N247BAArizona Wings LLC · Cave Creek, AZBuilt 1960 · S/N D-6391N247CBDream Machine Leasing LLC · Glenbrook, NVBuilt 1981 · S/N U20606194N247CPTl Sierra Properties LLC · Mammoth Lakes, CABuilt 2008 · S/N 3166N247DMGrimmett Lester · Clinton, MSBuilt 2005 · S/N 41506N247EFNobles Vernon H Jr · Calabasas, CABuilt 1968 · S/N 310P0023N247ESBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 9898N247GMSijan LLC · Marriottsville, MDBuilt 2022 · S/N 8753N247GNTommy Hanka Farms LLC · Mission, TXBuilt 1968 · S/N TC-1119N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637N247JWWl Aviation LLC · Valdosta, GABuilt 2010 · S/N E-3935N247KMNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1975 · S/N U20602872N247LVRlv Aviation LLC · Valdosta, GABuilt 2025 · S/N 10854N247MFsvc Aero Inc · Wilmington, DES/N 288N247MCGray Gary Mario DBA · Tampa, FLBuilt 2008 · S/N 411060N247PCSky Pilot LLC · Naples, FLBuilt 2015 · S/N 2286N247RJDead Broke LLC · Wilmington, DEBuilt 2007 · S/N E-3822N247SRPsalmbird Aviation LLC · Ormond Beach, FLBuilt 2007 · S/N 2457N247TSCrosswind Aviation LLC · Enid, OKBuilt 2015 · S/N 4280N247VBM&V Aviation Holdings LLC · Dover, DEBuilt 2015 · S/N T24002089N247WMNsfm Av LLC · Page, AZBuilt 2022 · S/N 8626N247WYBrimen Aviation LLC · Brookings, SDBuilt 2026 · S/N 11368N248G E Flight Services LLC · Clarksdale, MSBuilt 2001 · S/N EA-678N2480GGassaway Mitchell E · Carrollton, TXBuilt 1959 · S/N 51780N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299N2481CPippert Jim · Dysart, IABuilt 1954 · S/N 30781N2481GEaster Brett D · Enumclaw, WABuilt 1959 · S/N 51781N2481REngh Robert G · Laurel, MTBuilt 1964 · S/N 18255581N2481UWilliams Jeremy · Searsport, MES/N U20602380N2482CMiller Richard W · Bellingham, WABuilt 1954 · S/N 30782N2482QFox John E · Boonville, CABuilt 1966 · S/N 18257682N2482TTouchpoint International Development Group Inc · Fayetteville, NCS/N NAV-4-2482N2483FMiller Clinton J · Traverse City, MIBuilt 1966 · S/N 18051685N2483GLenox Mark W · Idaho Falls, IDS/N 51783N2483JWestern Pilot Service Inc · Phoenix, AZBuilt 1979 · S/N 18803467TN2483QMarch Kenrick D · Kingwood, TXBuilt 1966 · S/N 18257683N2483RSkydive Twin Cities LLC · Baldwin, WIS/N 18255583N2484CLejeune Aerial Applications LLC · Basile, LABuilt 1954 · S/N 30784N2484FJones William Ransom · Anchorage, AKBuilt 1966 · S/N 18051686N2484TAmetza LLC · El Centro, CABuilt 1962 · S/N NAV-4-2484N2485GBack Country Guys LLC · Prescott, AZBuilt 1959 · S/N 51785N2485QPayne Scott M · Twin Bridges, MTBuilt 1966 · S/N 18257685N2485SBrewer Lester A · Magna, UTS/N 337-0785N2485TRothrock Virgil N · Streator, ILBuilt 1962 · S/N NAV-4-2485N2486CArmstrong Patrick Trustee · Bishop, CABuilt 1954 · S/N 30786N2486GDenton Bob · Nampa, IDBuilt 1959 · S/N 51786N2486RCain James W · Big Rapids, MIBuilt 1964 · S/N 18255586N2486SDarvek LLC · Las Vegas, NVBuilt 1967 · S/N 337-0786N2486XGreat Escape Aviation LLC · Marquette, MIBuilt 1965 · S/N 18256386
Back to AD 2000-23-21