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.

N323RCTigers Aviation LLC · Wasilla, AKBuilt 1980 · S/N EA-87N323TJGuardian Wings LLC · Fredericksburg, VABuilt 1983 · S/N T30300243N323TLPrime Aviation Leasing LLC · Westlake, TXBuilt 2014 · S/N 4035N323TSKnippen Ronald M · Fort Jennings, OHBuilt 1982 · S/N 18268154N323UShaneyfelt Samuel J · Shady Shores, TXBuilt 1966 · S/N D-8029N323WWhitewings Aviation LLC · Milton, GABuilt 2005 · S/N 1509N323WDDurand Paul C · Osceola, WIBuilt 2006 · S/N 2085N323XLedgerwood Chris · Anchorage, AKBuilt 1975 · S/N 6131CN323YManthei Kurt E · Jacksonville, FLBuilt 2006 · S/N 42539N3240NAir Services Of Mississippi Inc · Mccomb, MSBuilt 1995 · S/N E-2980N3240SBenson Richard T · Bend, ORBuilt 1964 · S/N 18255740N3241YNull James A III · Live Oak, TXBuilt 1962 · S/N 18254241N3242SBateman Amber · Elizabeth City, NCBuilt 1964 · S/N 18255742N3242YShadow Air LLC · Norfork, ARS/N 18254242N3243BKcirro LLC · Portland, ORBuilt 1999 · S/N E-3243N3243COrthopaedic Surgery Institute Of California Mc · Newport Beach, CABuilt 1995 · S/N EA-575N3243UGlobe Motorcycles Ltd Inc · Pembroke Pines, FLBuilt 1963 · S/N 18254643N3244DBrooks Laura · Palmer, AKBuilt 1955 · S/N 32042N3244YCutrell William J · Mc Donald, TNBuilt 1962 · S/N 18254244N32456Bas Part Sales LLC · Greeley, COBuilt 1974 · S/N 34-7570023N3246BRb3246b LLC · La Follette, TNBuilt 1995 · S/N TH-1746N3246DJaden H Erwin Dds Pllc · Helena, MTBuilt 1955 · S/N 32044N3246EKauffman Gerald E · Bedford, PABuilt 1982 · S/N 18268239N3246RRegistered aircraftBuilt 1995 · S/N E-2946N3246UGregory Group LLC · Norwalk, CTBuilt 1963 · S/N 18254646N3247PCary Leasing & Management LLC · Boerne, TXBuilt 1999 · S/N EA-647N3247XExcalibur Aviation LLC · Spencer, IABuilt 2000 · S/N E-3347N3248DPalmer Cade E · Eagle River, AKBuilt 1955 · S/N 32046N3248LPreferred Management Corp · Shawnee, OKBuilt 1995 · S/N TH-1748N3248SHanson Glen W · Anchorage, AKBuilt 1964 · S/N 18255748N3248TBrydon Robert J · Austin, TXBuilt 1995 · S/N E-2948N3249DBielanski Allan · Larkspur, COBuilt 1995 · S/N E-2949N3249JSelge Leasing Inc · Niles, MIS/N E-3349N3249UHutchison Roger R · Sioux Falls, SDBuilt 1963 · S/N 18254649N324ABLightning Aviation LLC · Parrish, FLBuilt 2015 · S/N 0999N324AJ324 Aj LLC · Roseville, CABuilt 2024 · S/N 9963N324BHN324bh LLC · Roanoke, VABuilt 2025 · S/N E-4162N324BRBlue Ridge Aviation Holdings LLC · Boone, NCBuilt 2015 · S/N 4194N324CDWalker Synergy Partners 367 Inc · Encinitas, CABuilt 2026 · S/N 11419N324DBush David M · Englewood, COBuilt 1965 · S/N D-8016N324EAWaytack LLC · Bryant, ARBuilt 2015 · S/N TH-2452N324GEGreat Aviation LLC · Michigan City, INBuilt 2025 · S/N 10956N324GT324 Aviation LLC · Cavour, SDBuilt 1979 · S/N EA-38N324QLove Charles Keith · Asheville, NCBuilt 1999 · S/N TH-1909N324RDGood Voyage LLC · Sullivans Island, SCBuilt 2021 · S/N 5134N324RHPhillips William L Trustee · E Hampton, MABuilt 1979 · S/N 18267211N324RJSchelhorn Timothy J · Nampa, IDS/N 18254601N324SRThree Bell Aviation LLC · Dallas, TXBuilt 2007 · S/N 2458N324WYBig Sky Aviators LLC · Helena, MTBuilt 2018 · S/N 1750N324YCesscon LLC · Yalesville, CTBuilt 1976 · S/N 18264524
Back to AD 2000-23-21