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.

N448LMKinzler William · Tierra Verde, FLBuilt 2007 · S/N 2893N448SPWilliams Donald B · Sharps Chapel, TNBuilt 1964 · S/N TC-768N448SRAquatic Resources Management LLC · Lexington, KYS/N 1048N448TTScher Steven A · Sonoma, CABuilt 2008 · S/N 3073N448VAGr5 Aviation LLC · Branchburg, NJBuilt 2026 · S/N 11148N448WBLda Aerial Services LLC · Alcoa, TNBuilt 2025 · S/N 10799N449Destroyla Inc · Los Angeles, CABuilt 1969 · S/N 18052100N44903Treehouse Aviation LLC · Tuscaloosa, ALBuilt 1977 · S/N 28R-7703341N4490WFrisch Josef C · Belmont, CABuilt 1974 · S/N TC-1683N4492JJohnson Richard E · Waynesboro, MSBuilt 1980 · S/N TH-1199N4492SD K Boyer LLC · Melbourne, FLBuilt 1975 · S/N E-710N4493SRudrud David O Trustee · Scottsdale, AZBuilt 1975 · S/N D-9792N44941Herboldsheimer Dixon · Westminster, COBuilt 1977 · S/N 28R-7703344N44945Valiair Lc Trustee · Casper, WYBuilt 1977 · S/N 34-7770378N4494SLayer Scott E · Palm Harbor, FLBuilt 1975 · S/N E-709N4494WConlon James E Jr · Troy, NYBuilt 1974 · S/N D-9614N4495KCrawford William A · Batavia, OHBuilt 1948 · S/N NAV-4-1495N44962Johnson Bud W · Cedar City, UTBuilt 1977 · S/N 28R-7703350N44966Gillette Scott A · Lancaster, CABuilt 1977 · S/N 28R-7703351N44968Mil2atp Inc · Pikeville, NCBuilt 1977 · S/N 34-7770380N4496QWhitfield Robert O Jr · Hurdle Mills, NCBuilt 1972 · S/N 18800896N4496SHme Holdings Group LLC · Franklin, INBuilt 1975 · S/N D-9793N4497SFrazier Ford P · Oakland, CABuilt 1975 · S/N CE-592N44980Evans Jeffrey T · Hannibal, MOBuilt 1980 · S/N E-1658N4498SHaskins Scott · Spring Hill, KSBuilt 1975 · S/N E-714N44995Fenton Flyers LLC · Ellisville, MSS/N 28R-7703352N449DWWalt David L · Clarkston, MIFirst renewal noticeBuilt 1977 · S/N 28R-7703349N449LLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N EA-332N449MRockys Aviation LLC · Portland, MEBuilt 2025 · S/N 10931N449SFKyle Allyn B · Snohomish, WABuilt 1957 · S/N 50013N449SRCline Aviation LLC · Travelers Rest, SCBuilt 2006 · S/N 1980N449TSmallwood David · Oak Ridge, TNBuilt 1970 · S/N D-9153N449VYKirkham Matthew · Cazenovia, WIBuilt 1973 · S/N 18262199N449WMWissman Enterprises LLC · Lincoln, NEBuilt 2012 · S/N 3869N44ARounds Don DBA · Waller, TXS/N G-723N44AEMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 347870240N44AGVanderpool Gary W · Alamo, TXBuilt 1966 · S/N 188-0138N44CCoyne Greg · Hondo, TXBuilt 1979 · S/N P21000311N44CBClint Bowyer Racing Inc · Clemmons, NCBuilt 2025 · S/N 11022N44CCColumbia Club Aero LLC · East Wenatchee, WABuilt 1971 · S/N 18260646N44CFFly Low Aviation LLC · Smithville, MSS/N 21059764N44CGBlackwolfden Aviation LLC · Belgrade, MTBuilt 1979 · S/N 25-0187N44CMRussell Stephen J · Chester, VTBuilt 1969 · S/N D-8927N44CTCadeco · Rochelle, TXBuilt 2023 · S/N 9581N44CYMiskell Christopher S · Senoia, GABuilt 1973 · S/N TC-1629N44DADuncan Aviation Inc · Lincoln, NEBuilt 1981 · S/N E-1841N44DBSperr David F · Rock Hill, SCBuilt 1959 · S/N D-6074N44DGTime Flies LLC · Fort Worth, TXS/N 055N44DPD L S Aviation Inc · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N 310P0039N44DRFiretextresponse LLC · Sumner, ILBuilt 1975 · S/N 18263596
Back to AD 2000-23-21