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.

N4176BWard William R · Titusville, FLBuilt 1975 · S/N 75-30781N4176SVortex Maritime · Chesapeake, VABuilt 1975 · S/N TC-1860N4177QAdamson Paul · Sparks, NVBuilt 1968 · S/N 310N-0077N4177SMiles Insurance Inc · Inverness, ILBuilt 1975 · S/N D-9757N41782Kansas Soaring Assoc Inc · Wichita, KSBuilt 1955 · S/N 613N4178AObrien Michael J · San Juan Capo, CABuilt 1952 · S/N G-20N4178SGlad Aviation LLC · Gilford, NHBuilt 1975 · S/N TH-652N417AKViking Cake Holdings II LLC · Bend, ORBuilt 2017 · S/N 1625N417ATAuctioneer Wings LLC · Valparaiso, INBuilt 2025 · S/N 10417N417BSMojo Aviation LLC · Overland Park, KSBuilt 2018 · S/N 1739N417DASkylark Holdings LLC · Costa Mesa, CABuilt 2023 · S/N 9093N417DTCirrus Turbo N417dt LLC · Newark, DEBuilt 2026 · S/N 11255N417EC417ec LLC · Sheridan, WYBuilt 1972 · S/N 310Q0539N417EESouth Pass Aviation LLC · New York, NYBuilt 2025 · S/N 10822N417JRBinary Ninjutsu LLC · Myrtle Beach, SCS/N 0222N417KKinsley Joshua P Trustee · Carlsbad, CABuilt 1999 · S/N E-3269N417KHWillens Mark D · Livermore, CABuilt 2010 · S/N 3657N417LCFowm LLC · West Memphis, ARBuilt 2016 · S/N 4367N417LFRussell Tommy Edward · Kingsport, TNBuilt 1976 · S/N 18264714N417MKRegistration Pending · Reno, NVRegistration pendingBuilt 1977 · S/N 28R-7703192N417MMN417mm LLC · Kirkwood, MOBuilt 2007 · S/N 2332N417PWFleur De Lis Krewe LLC · Orlando, FLBuilt 2006 · S/N 1929N417TABrickler Alexander J · Tallahassee, FLBuilt 2002 · S/N 0241N417WCMpi Warehouse Specialty Company Inc · Casper, WYBuilt 1985 · S/N EA 451N417WDWheels Down LLC · Oklahoma City, OKBuilt 2014 · S/N 4162N418Vpropnw Inc · Walla Walla, WABuilt 1966 · S/N 359N4180SPalomino Princess Express LLC · Helena, MTS/N D-9755N4181QMontgomery Steven D · Cleveland, OKBuilt 1968 · S/N 310N-0081N4181SArizona Type Ratings LLC · Sedona, AZBuilt 1975 · S/N E-672N4181TKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320D0081N4182SSassine Alain · Estero, FLS/N E-668N4183QSpurlock Daniel C · Harrogate, TNBuilt 1968 · S/N 310N-0083N41849Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 3449179N4184BWitt Aaron K · Hooker, OKBuilt 1974 · S/N 75-30742N4184QBluesky Airline LLC · La Crescenta, CAS/N 310N-0084N4185MRoom Nine LLC · Casper, WYBuilt 1974 · S/N 18502416N4185PFlying Woody LLC · Helena, MTBuilt 1970 · S/N 185-01651N4185SJetset Aviation LLC · Helena, ALBuilt 1975 · S/N CE-575N4186TRegistered aircraftBuilt 1966 · S/N 320D0086N4187SJ&S Aviation Services LLC · Hastings, NES/N D-9765N4188SMajor Air LLC · Charleston, SCBuilt 1975 · S/N TH-620N4188YSandberg Steven R · Malta, ILBuilt 1962 · S/N 185-0388N4189SHigh Planes Holdings LLC · Lexington, NEBuilt 1975 · S/N E-676N418BCFlying Beep LLC · Athens, GABuilt 2016 · S/N 4372N418DKKnies Aviation Inc · Huntsville, ALBuilt 1964 · S/N 21058435N418DPPiotrowski Enzo · Miami, FLBuilt 1976 · S/N 34-7670239N418DZDeman Richard · Nyack, NYBuilt 2013 · S/N 2236N418GFlight 762 LLC · New Orleans, LABuilt 1966 · S/N 310K0067N418GVWings & Rotor LLC · Wilmington, DEBuilt 2024 · S/N 10304N418JCWalker Richard A · Omaha, NEBuilt 2004 · S/N 1132
Back to AD 2000-23-21