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.

N213ARAdelle Aviation LLC · Sacramento, CABuilt 2013 · S/N 0623N213BGUpstate Flyers LLC · Woodruff, SCBuilt 1972 · S/N 18261580N213CAAble 1 Aviation Inc · Las Vegas, NVBuilt 2014 · S/N 4094N213CFSchantz David E Trustee · Raleigh, NCBuilt 2022 · S/N 8557N213CGThomas Leasing LLC · Niota, TNBuilt 2016 · S/N 1409N213CNCullem Daniel F · Soquel, CABuilt 1980 · S/N TC-2298N213CPTitsworth Richard D · Novi, MIBuilt 2008 · S/N 3142N213DRCon-Ag Rentals Inc · Blairsville, GAFirst renewal noticeBuilt 1999 · S/N E-3247N213EOliver Craig J · Orion, MIBuilt 1965 · S/N TE-40N213GCEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 21062368N213JDS&C Vending LLC · Scottsbluff, NES/N 310R0136N213JPEducators Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608030N213JWLipidex Corp · Marshfield, MABuilt 2004 · S/N 1089N213KSTenedos LLC · Tacoma, WABuilt 2017 · S/N 1490N213KTCirrus Middle East Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11576N213LBPetro Larry D · Washington, DCBuilt 2004 · S/N 42051N213LMDavis Aircraft LLC · Sarasota, FLBuilt 2023 · S/N 9458N213MRogers Ronald J · Crystal Lake, ILBuilt 1978 · S/N 310R1335N213MEMcgough Craig N · Ferris, TXBuilt 1958 · S/N D-5686N213MLTrue Air Speed LLC · Saint Francisville, LABuilt 2020 · S/N 4886N213MPFly High Aircraft Sales LLC · Ocilla, GABuilt 2025 · S/N 10767N213PBKofman Peter M · Mountain Grove, MOBuilt 1959 · S/N D-5791N213PG213pg Inc · Chattanooga, TNBuilt 2022 · S/N 8702N213QHardcopf Robert W · Apple Valley, MNBuilt 1965 · S/N D-7929N213RJCrw Enterprise Holdings LLC · Newark, DEBuilt 2003 · S/N 0737N213SEAircraft Partner N213se Dst · BerlinS/N 2391N213SRDonegan Kevin M · Amissville, VABuilt 2006 · S/N 2100N213TBDonley John Roger · Eagle Lake, FLS/N 1056N213TWPonozzo Donald A · Muskegon, MIBuilt 2023 · S/N 3FX043N213WDHamill Enterprises LLC · Reinholds, PABuilt 2004 · S/N 1121N213ZWhite Gregory D · Enterprise, ALBuilt 1964 · S/N TC-672N21401Sterling Steven G · Richland, WABuilt 1972 · S/N 18261612N21402Hester James Timothy · Fayetteville, GABuilt 1972 · S/N 18261613N21404Usglap · Fort Morgan, COBuilt 1972 · S/N 18261615N21405Brushwood John W · Coshocton, OHBuilt 1972 · S/N 18261616N2140DEaton Darryl S · Santa Barbara, CABuilt 2000 · S/N 30-0044N2140GBoger Malcolm L · Dickens, TXBuilt 1958 · S/N 51440N21414Flyboys Flying Club LLC · Pawleys Island, SCBuilt 1972 · S/N 18261624N21416Campbell David Lloyd · Fredericksburg, TXBuilt 1972 · S/N 18261626N2141FHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0341N2141GFreiheit Larry · Clinton, MOBuilt 1958 · S/N 51441N2141LErwin James Erskine III · Newnan, GABuilt 1976 · S/N E-896N21421Paul Janet K · Beaver Island, MIBuilt 1972 · S/N 18261630N2142MWatson Kenneth · Atlanta, GABuilt 1979 · S/N 28R-7931040N21434Ad-A-Note LLC · Tarentum, PABuilt 1998 · S/N 29-0159N21439Baxter Lawrence E · Reno, NVBuilt 1997 · S/N 25-2017N2143JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N TH-1855N2143SBaiocchi Ken P · San Jose, CABuilt 1975 · S/N 21061104N21445Woody Dwain F Trustee · Lubbock, TXBuilt 1972 · S/N 18261632N2144JCraft James Thomas Jr Trustee · Clinton, MSBuilt 1978 · S/N 28R-7931010
Back to AD 2000-23-21