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.

N444HPCrosswind Aviation Inc · Oakley, KSBuilt 1979 · S/N 28R-8031003N444HTTaktos Ltd · Corvallis, ORBuilt 1973 · S/N 310Q0739N444JHCirrusly Fast J2911 LLC · Duson, LABuilt 2016 · S/N 4376N444JMPeck Joseph A · Pound Ridge, NYBuilt 1976 · S/N 340A0280N444JSIndigo Of South Fl Inc · Sunrise, FLS/N 28R-7703287N444KKHeartland Tank LLC · Ponca City, OKBuilt 2023 · S/N 9584N444KTHangar G-1 Aviation Partners LLC · Los Olivos, CABuilt 1981 · S/N 340A1235N444KWRaw Racing Inc · Puyallup, WAS/N 340A0241N444KY444 Dd LLC · Chavies, KYBuilt 2018 · S/N TH-2497N444LFBourbon Richards LLC · Tempe, AZFirst renewal noticeBuilt 2006 · S/N LIV522N444LJDsl Aviation LLC · Ronkonkoma, NYBuilt 1978 · S/N 310R-1294N444LLWolfson Alan B · Loveland, OHBuilt 1962 · S/N 18254063N444LSTaa Property LLC · Lake Wales, FLBuilt 1973 · S/N 414-0460N444MFChampagne Cruises Ltd · St Thomas, VIBuilt 2002 · S/N 0174N444NPJc Aviation LLC · Raleigh, NCBuilt 2026 · S/N 11204N444PAExecutive Aviation LLC · Peoria, AZBuilt 1979 · S/N 34-7970324N444PGN444pg Aviation LLC · Charleston, SCBuilt 1998 · S/N E3218N444PJWagner Aviation LLC · Laura, OHBuilt 1974 · S/N 21060433N444PTCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11601N444RGKalasky Sean W · Jacksonville Beach, FLBuilt 1976 · S/N CE-644N444RSRomeo Sierra Aviation LLC · Gilbert, AZBuilt 2022 · S/N 9017N444RUFitzgerald Paul · Grapevine, TXBuilt 1973 · S/N D-9441N444RWBackus Gary Carl · Chesapeake, VABuilt 1979 · S/N 21063465N444SRr&D Lp · Fayetteville, NCBuilt 1985 · S/N TJ-490N444SBN1849p LLC · Wilmington, DEBuilt 2008 · S/N E3844N444TCHalstead Land & Cattle Inc · Arnold, NEBuilt 1975 · S/N D-9783N444TKFahl James E · Sparks, NVBuilt 1981 · S/N 25-0576N444UJAmbush Aviation LLC · Anabel, MOBuilt 2005 · S/N 1348N444VPBalzer Joseph W · Sevierville, TNBuilt 1962 · S/N NAV-4-2432N444VRBarber Casey John · Visalia, CABuilt 2003 · S/N 0788N444WAWiseman Aviation Inc · Flagstaff, AZBuilt 1961 · S/N 1130-60N444WELiberty Steaks LLC · Latham, NYBuilt 2004 · S/N E-3579N444WLX-Perimental Aircraft LLC · Kenosha, WIBuilt 1994 · S/N 7N444WRNuccio Jeffrey W Trustee · Signal Mountain, TNBuilt 1977 · S/N D-10012N444XSmart Visual Systems LLC · Georgetown, TXBuilt 1958 · S/N D-5716N444XDAshanti Aviation LLC · Flemington, NJBuilt 2016 · S/N L2K-339N444XPEiron Nadav · Portola Valley, CABuilt 1969 · S/N 18052051N4451SCaporale Ron · Dillon, MTBuilt 1975 · S/N E-683N4451WFlying On Edge LLC · Redmond, WABuilt 1974 · S/N CE-491N4452WHubbard Mark A · Wilmington, DEBuilt 1974 · S/N D-9611N4453QKeene Greggory L · Abbeville, GABuilt 1971 · S/N 18800853N4455Sanders Russell · Canton, GAS/N 41048N44552Hemdmm Corp · Wilmington, DEBuilt 1974 · S/N 34-7570003N4455BBriggs Robert B · Germantown, TNBuilt 1979 · S/N TC-2203N4455QHaring Clay DBA · Lincoln, KSBuilt 1971 · S/N 18800855N4455SFlying Adventures LLC · Uniondale, NYS/N TC-1875N4455VHorsefly Aviation LLC · Helena, MTBuilt 1965 · S/N CD-1006N4456SFressh Air LLC · Vancouver, WABuilt 1975 · S/N E-688N4456WMetal Finishing Co Inc · Wichita, KSBuilt 1974 · S/N E-537N4457SRegistered aircraftBuilt 1975 · S/N D-9775
Back to AD 2000-23-21