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.

N2299XSturgeon Keith A · Saginaw, TXS/N 337-0199N229ATN312sp LLC · Glen Allen, VABuilt 2024 · S/N 10030N229CN229c LLC · Holt, MOFirst renewal noticeBuilt 1965 · S/N 18256129N229CDGurley Eric · Omaha, NEBuilt 2001 · S/N 1131N229CSChicostate Aviation LLC · Wilmington, DEBuilt 1960 · S/N 52363N229DTEyes In The Skies LLC · Oklahoma City, OKBuilt 2012 · S/N 3850N229DWSpringline Ventures LLC · Orlando, FLBuilt 2024 · S/N 10319N229ESLastowski Jeffrey A · Mooresville, INBuilt 1967 · S/N CE-174N229FSmith Dennis L · Burbank, CABuilt 2006 · S/N 2299N229FDN229fd LLC · Myrtle Beach, SCBuilt 2025 · S/N 10399N229GMThibault Thomas N · Granbury, TXBuilt 2012 · S/N LIV-386N229HN35ta LLC · Boxford, MABuilt 2024 · S/N 9830N229LSLss Leasing LLC · Thomasville, GABuilt 2026 · S/N 11350N229PALussier John A · Greene, RIBuilt 1951 · S/N 22967N229QMike Lima Partners LLC · Wilmington, DEBuilt 1966 · S/N D-8169N229RHMew Enterprises LLC · Imperial, NEBuilt 2015 · S/N 1113N229RMMjt Real Estate Holdings LLC · Orlando, FLBuilt 2002 · S/N 0416N229SG229sc LLC · Fayetteville, GABuilt 2006 · S/N 1956N229TTWcps Aviation LLC · Marietta, GABuilt 2010 · S/N E-3929N229TXTango Xray Aviation LLC · Logan, UTFirst renewal noticeBuilt 2011 · S/N 0076N229VAGerrard Roger I · Repton, ALBuilt 2020 · S/N XLR5-101N229WARoyal Skies LLC · Yakima, WABuilt 2013 · S/N 0616N229WWMcgregor Daniel A · Denali Park, AKBuilt 1973 · S/N U20601807N22ABKimhi Transportation LLC · Woodland Hills, CABuilt 2015 · S/N 1144N22ADMorganav Inc · Chapel Hill, NCBuilt 2018 · S/N 4641N22AGMavridoglou Theo A · Brandon, MSBuilt 1973 · S/N D-9499N22AHMalchoff Keith B Jr · Yuma, COBuilt 1970 · S/N 30327N22AMJays Aircraft Maintenance Inc · Costa Mesa, CABuilt 1979 · S/N 310R1634N22AYRegistration Pending · Lebanon, PARegistration pendingBuilt 2004 · S/N 1176N22BSSmith Aviation Inc · Wilmington, DEBuilt 1976 · S/N TC-1928N22BYDelton LLC · Pembroke Pines, FLBuilt 1964 · S/N D-7609N22CRegistered aircraftBuilt 1958 · S/N 51007N22CAN22ca LLC · Ennis, MTBuilt 2008 · S/N 421003N22CBVollstedt Gregory Scott · Anchorage, AKBuilt 1973 · S/N 185-02188N22CCLegacy Air LLC · Oklahoma City, OKBuilt 1984 · S/N TJ-471N22CE0 To 100 Aviation LLC · Palmetto Bay, FLBuilt 2020 · S/N 4918N22CFGame Equipment Services LLC · Midland, TXBuilt 1961 · S/N 18253217N22CMDavis Frederich K · Dunbar, PABuilt 1965 · S/N 337-0159N22CVMcginley Donald J · Port Orange, FLBuilt 1973 · S/N 21059974N22CWFoxy Investments LLC · Alpine, WYBuilt 2013 · S/N 0601N22CYHughes Jason David · Hickory, NCBuilt 2008 · S/N 3085N22DBSalisbury Mark J · Green Cove Springs, FLBuilt 2002 · S/N 0205N22DGSeequs Inc · Greenwood Village, COBuilt 2023 · S/N 9229N22DMM1 Aviation LLC · Trenton, NJFirst renewal noticeBuilt 2007 · S/N 2886N22DRScott Aero LLC · Hudson Oaks, TXS/N 73-30596N22DSSwartwout David C · Sedona, AZBuilt 1961 · S/N CD-446N22DXHawk Daniel G · Cocoa, FLBuilt 1958 · S/N 51442N22ECDoose Christopher A · Memphis, TNBuilt 1973 · S/N 310Q0732N22EDGrant Douglas R · Foster City, CAFirst renewal noticeBuilt 1954 · S/N D-3820N22EGEsm Aviation LLC · Pomona, NYBuilt 2006 · S/N 2234
Back to AD 2000-23-21